Pivot table - row sum not available in all columns

[anagharao]

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.

[anagharao · Accepted solution]

This worked:

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