I cannot find ANY help with what proper references to use for this. If my report has only one column to the matrix (first screenshot), the following Formula works to product percentages per row in the one column. If I have MORE than one column, it produces the data based on ALL columns (100% for the entire table, not per column). Can someone guide me on how to adjust the formula to work "per column" so each column totals 100%?
RowCount / PARENTGROUPVAL( RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)
Screen 1 = one column, no problem:
Screen 2 = problem: