Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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