topic Totals Amounts in Pivot Table in QlikView

Totals Amounts in Pivot Table

Thu, 10 Mar 2011 19:00:46 GMT

Dears,

Good day.

I have a pivot table that shows amounts (expressions) in different items (dimensions). What I want to show is the total amounts of each row (right side) and each column (bottom side).

Is possible to do that??, if possible, How can I do it?

Many thanks in advance.

Mauriccio

Totals Amounts in Pivot Table

Thu, 10 Mar 2011 19:43:12 GMT

Hi,

If you turn on partial sums on the presentation tab of properties, you will get the totals at the bottom of each column. Then if you simply pivot one of your dimensions, you will get the matching totals to appear on the right hand side.

I hope this helps

Thanks

Nick

Totals Amounts in Pivot Table

Thu, 10 Mar 2011 20:34:18 GMT

Dear Nick,

Many thanks for your advice.

Actually, I have done what you suggest and it works fine for the columns, however when I pivot one of my dimensions, it doesn't appear total amounts for rows at all.

Do you know why?

Mauriccio

Totals Amounts in Pivot Table

Thu, 10 Mar 2011 20:39:30 GMT

Hi Mauriccio,

Do you have partial sums set for all of the dimensions?

Thanks

Nick

Totals Amounts in Pivot Table

Thu, 10 Mar 2011 20:58:43 GMT

Dear Nick,

Good point!!, now it works perfectly. Many thanks mate!!...

Mauriccio