Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This worked:
num(SUM([SALE AMT]) / SUM(TOTAL <[OFFICE - 1],[OFFICE - 2]> [SALE AMT])),'#0.00%')
This worked:
num(SUM([SALE AMT]) / SUM(TOTAL <[OFFICE - 1],[OFFICE - 2]> [SALE AMT])),'#0.00%')