I've got a pivot table which shows me the total of Sales for different dates.
How to add a new column which shows me the totals for all dates?
F.e: extra colum "Total" first row 7,00 + 1,88 = 8,88
Go in presentation bar, click on the field (they are in a list box on the top left of the tab) then click on show partial sum
let me know ...
I am not able to edit this field (grey-out).
It's possible to edit the partial sum for dimensions, not for the expression
Go Chart Properties>Presentation>Check on show partial sums.While doing this the dimension 'Datum' should be selected in the Dimensions & Expressions box present in the Presentation tab.
Retrieving data ...