Matrix Reports - Displaying percentage based on column totals instead of the Grand Total
RowCount/PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)
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?