You need to sign in to do that
Don't have an account?

Matrix Reports: Get the percentage of the record per row
Hello,
Would someone help me on how to get the % of the record per row. the computation should be against the total record per row not the whole table.
i have this:
RowCount / PARENTGROUPVAL( RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)
but it gets the percentage against the whole table not per row.
@SteveMo - i think i saw this from your example from a different site. cant rember..:)
Thanks,
Del
Would someone help me on how to get the % of the record per row. the computation should be against the total record per row not the whole table.
i have this:
RowCount / PARENTGROUPVAL( RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)
but it gets the percentage against the whole table not per row.
@SteveMo - i think i saw this from your example from a different site. cant rember..:)
Thanks,
Del


Please see if this helps: https://success.salesforce.com/answers?id=90630000000gprVAAQ