Ask Search:
John WeymouthJohn Weymouth 

Matrix Reports - Displaying percentage based on column totals instead of the Grand Total

I have a matrix report that I need to display percentages. When I use the formula below, it displays the percentage of Grand Total: 

RowCount/PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)
User-added image
This is nice, but what I really need is the percentage of the Column total displayed within the matrix (not below in the totals). So the first office column should display 40% (because it is 2 of 5) instead of 5.13% (2 of 39).

Does anyone know how to do this please?
Best Answer chosen by John Weymouth
Steve MolisSteve Molis
Like this?
1
User-added image
2
User-added image