Skip to main content
How can I work out the percentages of the total for a Record Type in a Matrix report?

 

I have a Matrix report which shows the sales figures for both New Business and Part-Exchange. These are two Opportunity Record Types. I have the report grouped by Owner.

 

I want to see the % of business for each Owner and the total.

 

For example... (figures are examples only - not correct %'s)

 

How can I work out the % for a the total of a Record Type in a Matrix Report?

 

What I currently have shows this...

 

User-added image

 

My formula references the GRAND_SUMMARY but I actually need it to reference the summary for each Record Type... Is this possible?

 

User-added image

 

I have 4 formulas of the same set up. One for each of the available summary levels....
3 respuestas
0/9000