Pivot table - row sum not available in all columns

anagharao — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone

I'm trying to find the % of sales per office type by customer type.

I have two dimensions - Office type and customer type. I've create a pivot and the tried to divide the amount in each cell by the row sum of that row:

num(SUM([SALE AMT]) / SUM(AGGR(SUM([SALE AMT]),[OFFICE - 1],[OFFICE - 2])),'#0.00%')

However the row total does not appear in all columns and shrinks the pivot table to few numbers.

Re: Pivot table - row sum not available in all columns

anagharao — Mon, 24 Sep 2018 13:25:03 GMT

This worked:

num(SUM([SALE AMT]) / SUM(TOTAL <[OFFICE - 1],[OFFICE - 2]> [SALE AMT])),'#0.00%')

topic Re: Pivot table - row sum not available in all columns in QlikView

Pivot table - row sum not available in all columns

Re: Pivot table - row sum not available in all columns