topic How do I get Column Totals in a Pivot Table? in QlikView

How do I get Column Totals in a Pivot Table?

Fri, 18 Sep 2009 00:48:06 GMT

Can get simple column totals in a STRAIGHT TABLE BUT, NOT IN A PIVOT TABLE.

How do I get Column Totals in a Pivot Table?

Oleg_Troyansky — Fri, 18 Sep 2009 00:54:58 GMT

Yes, unfortunately this is how it works... There is a work around though - use Advanced Aggregation (function aggr()) and force the summary of the detailed values at each level.

For example, if your Picot Table has 3 Dimnsions - Dim1, Dim2, and Dim3, and an expression sum(Sales), you could use the following expression to force Sum of lines:

sum(aggr(Sum(Sales), Dim1, Dim2, Dim3))

cheers!

How do I get Column Totals in a Pivot Table?

Fri, 18 Sep 2009 00:59:57 GMT

Have you looked at partial sums (Presentation tab)? If you put a partial sum on your top dimension, then that should total up the columns at the bottom. If you prefer your subtotals at the top that can be changed by using the Subtotal section of the Presentation tab.

How do I get Column Totals in a Pivot Table?

Fri, 18 Sep 2009 01:16:48 GMT

THANK YOU!