topic Re: Pivot Table row totals in QlikView

Pivot Table row totals

Fri, 09 Nov 2012 12:54:59 GMT

I have a pivot table and would like to show totals at the end of each row.

When I add 'show partial sum' this add it to the columns and not rows!

Can this be changed anywhere?

I've looked in all the properties and can't find anything that jumps out as row totals.

Andy

Re: Pivot Table row totals

jonathandienst — Fri, 09 Nov 2012 13:03:21 GMT

If you have pivoted any dimensions to column headings, you can total the rows using partial sums. If you have no dimensions in the column headings (ie only expressions), then the partial sum does not work. Instead, you can total the rows by creating a total expression that adds the columns:

=Column(1) + Column(2) + Column(3) .....

Hope that helps

Jonathan

Re: Pivot Table row totals

Fri, 09 Nov 2012 13:11:45 GMT

Thanks Jonathan

Much appreciated.

Andy

Re: Pivot Table row totals

Sheron-Al1 — Thu, 26 Jan 2023 23:51:38 GMT

Thank you. So simple.