topic Re: Add Column to Pivot Table in QlikView

Add Column to Pivot Table

Anonymous — Tue, 15 Oct 2013 18:23:04 GMT

I'm trying to add a total column to a pivot table. I've selected the "Show Partial Sums" check box on the presentation tab. This sort of works when only selecting one column but if multple columns are selected the total column isn't displayed. Any ideas how to do this? Here is an example of how it should look but with multiple columns instead of only one.

Re: Add Column to Pivot Table

sudeepkm — Tue, 15 Oct 2013 18:36:32 GMT

have you enabled "show partial sum" for all your dimensions.

Re: Add Column to Pivot Table

Anonymous — Tue, 15 Oct 2013 18:41:32 GMT

That worked, thanks!

Re: Add Column to Pivot Table

Anonymous — Tue, 15 Oct 2013 19:00:44 GMT

I thought that worked. Actually, it is giving me incorrect total amounts. Any ideas?

Re: Add Column to Pivot Table

Wed, 16 Oct 2013 01:24:49 GMT

hi.

use SUM(AGGR(SUM(EXPRESSION),DIMENSION))

regards

Gernan