Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anagharao
Creator II
Creator II

Pivot table - row sum not available in all columns

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.

1 Solution

Accepted Solutions
anagharao
Creator II
Creator II
Author

This worked:


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


View solution in original post

1 Reply
anagharao
Creator II
Creator II
Author

This worked:


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


View solution in original post