topic Re: Row and Column totals in pivot table in QlikView

Row and Column totals in pivot table

richard_chilvers — Wed, 18 Feb 2015 10:22:36 GMT

In a pivot table, I would like to show some dimensions totals in rows and some in columns.

I have searched this community and one advice is to use Subtotals on Top/Bottom. but this is making no difference; all totals appear at the bottom or top of columns, but never at the end of rows.

Any hints as to what I'm doing wrong ?

Thanks

Re: Row and Column totals in pivot table

jpenuliar — Wed, 18 Feb 2015 10:53:11 GMT

This might help:

Re: Row and Column totals in pivot table

morganaaron — Wed, 18 Feb 2015 11:03:51 GMT

Hi Richard,

If you pivot a dimension along the top, it's partial sums would by default then appear at the end of the row. You could create a total expression instead?

Re: Row and Column totals in pivot table

sujeetsingh — Wed, 18 Feb 2015 11:10:38 GMT

Try show totals at expressions

Re: Row and Column totals in pivot table

richard_chilvers — Wed, 18 Feb 2015 11:15:28 GMT

Thanks Jonathan

This is a useful example, and I have dimension-level formatting to good effect elsewhere.

Re: Row and Column totals in pivot table

richard_chilvers — Wed, 18 Feb 2015 11:19:10 GMT

Hi Aaron

Yes I do have a dimension along the top, and I'd want the totals for that dimension therefore be in a column.

But it seems that whatever combination of partial sums and top/bottom totals, they never appear as row totals.

I can create and experssion total, but I prefer to let QV do the work where possible