Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Did you try to add the partial sum for Period?
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.
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
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
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
Are you able to share a sample where you trying to do this? It might be easier for you to see it implemented
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
Brilliant, Thanks Very much.