Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have a pivot table as in the image below, I have moved Report Month column up so I can see the values as ccolumn headers and the calculations below the date. I want to add a new column that will calculate the total sum for all months for every row.
if I add a Total with that calculation, will go under the month, not for all months.
thank you!
Hi
Try to enable the "Show Partial Sums" for "Report Month" under presentation tab.
It will give the Total for the Month level
Hi
Try to enable the "Show Partial Sums" for "Report Month" under presentation tab.
It will give the Total for the Month level