Totals in Pivot table

[Abhishek1]

hi,

I am developing a dashboard in which a Pivot chart needs to show Totals. The Chart shows the count of Projects and the annual revenue by Phase and by month. We are showing this data for the latest two months Separately in chart. Please see the attached image for better understanding. 

The issue is The users want the Totals to show separately for every month in the end. just like the period is divided in every phase.

can anyone help?

[sunny_talwar]

Did you try to add the partial sum for Period?

[Abhishek1]

Hi Sunny,

Yes I did. It shows partial sum for every Phase separately. I dont want to show it like that. I want to show the Total in the end to show totals separately for each month.  Please find the images of the output after applying partial sum and what I am trying to achieve. Please see the Total section of the Desired_Output image.

[sunny_talwar · Accepted solution]

Try like this... create an island table in the script like this

LOAD * INLINE [
Dim
1
2
];

and then change Phase dimension to this
Pick(Dim, Phase, 'Total')

Sort order for this new dimension will use sort by expression
Only({1} Dim)*10000000 + any other sorting expression you have

[Abhishek1]

hi,

I understood that I have to create a data island named Dim. I am not clear what I have to do next. can you please explain a bit. sorry I am new here.

Thanks,

Abhishek

[Abhishek1]

hi Sunny,

I understood that I have to create a data island named Dim. I am not clear what I have to do next. can you please explain a bit. sorry I am new here.

Thanks

[sunny_talwar]

Are you able to share a sample where you trying to do this? It might be easier for you to see it implemented

[jaibau1993]

Hi both!

I made a simplified example to ilustrate Sunny's solution (it is fanstastic, by the way, so clever).

Please see the attached file, maybe it helps you understand Sunny.

Jaime

[Abhishek1]

Brilliant, Thanks Very much.