Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to add a column in a pivot table

I've got a pivot table which shows me the total of Sales for different dates.

pivotTotal.jpg

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

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.

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

Hi,

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.

Anonymous
Not applicable
Author

I am not able to edit this field (grey-out).

It's possible to edit the partial sum for dimensions, not for the expression