topic Re: How to add a column in a pivot table in QlikView

How to add a column in a pivot table

Anonymous — Thu, 11 Sep 2014 09:33:01 GMT

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

Re: How to add a column in a pivot table

alexandros17 — Thu, 11 Sep 2014 09:39:11 GMT

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

Re: How to add a column in a pivot table

Thu, 11 Sep 2014 09:44:34 GMT

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.

Re: How to add a column in a pivot table

Anonymous — Thu, 11 Sep 2014 09:46:17 GMT

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

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