Q
How do I find the percent of a total value grouped by row? I've tried the PARENTGROUPVAL but I don't think I'm using it correctly.
I have a report summing up the Account field "Total Contracted Revenue" for all Customers, broken down into rows by Industry. I want to know what percentage of the Grand Total TCV each Industry has. The chart feature easily allows me to do this ("Show %") but I can't figure out the formula to get this into my report.
So basically, for each row (Industry), I want to know what percentage of the report's Grand Total TCV (Total_Revenue_Received_from_Customer__c) each one has.
Ans
How do I find the percent of a total value grouped by row? I've tried the PARENTGROUPVAL but I don't think I'm using it correctly.
I have a report summing up the Account field "Total Contracted Revenue" for all Customers, broken down into rows by Industry. I want to know what percentage of the Grand Total TCV each Industry has. The chart feature easily allows me to do this ("Show %") but I can't figure out the formula to get this into my report.
So basically, for each row (Industry), I want to know what percentage of the report's Grand Total TCV (Total_Revenue_Received_from_Customer__c) each one has.
Ans
AMOUNT:SUM /PARENTGROUPVAL(AMOUNT:SUM, GRAND_SUMMARY)
No comments:
Post a Comment