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.
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.