Skip to main content
Topics#Data ManagementDea Simon's Question
Dea Simon (brightwheel) asked in #Data Management
Jan 16, 2020, 5:29 PM

How do I calculate the percentage of each column against the total?

I have a report:

 

How do I calculate the percentage of each column against the total?And I want to be able to either show the % of total for EACH column OR at least show the percentage of the total for each row.  The Lead Source - Detail column is a text field.  Any help is appreciated!
5 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Jan 16, 2020, 5:50 PM
    So like this? 

     

    So like this? Formula A:RowCount / PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, Test__c.Do_you_owe_SteveMo_a_beer2__c) Formula B:RowCount / PARENTGROUPVAL(RowCount , ACCOUNT.
    Formula A:
    RowCount / PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, Test__c.Do_you_owe_SteveMo_a_beer2__c) 
    Formula B:
    RowCount / PARENTGROUPVAL(RowCount , ACCOUNT.NAME, COLUMN_GRAND_SUMMARY) 
    Formula C:
    RowCount / 
    PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)

     

     
Write an answer...
0/9000