Need this project schedule requirement using OTBI

Summary:

Hi

we have the below requirement. Please let us know how this can be done using OTBI

This is sample data

Date-wise aggregation of data to be done as shown below.

Then we need to transpose and need this data

If not possible via OTBI, please let us know which tool to be more appropriate.

Appreciate your response on this.

Content (required):

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):