Report summary formula help

Question

I have a report with two groupings, Owner and Source. For each owner grouping, there are three different sources, like below:

-Bob

-->Marketing

-->Sales

-->Magic

-Jessica

-->Marketing

-->Sales

-->Magic

All I want to see is the percent each source makes up of each owner, like below:

-Bob

-->Marketing - 30%

-->Sales - 20%

-->Magic - 50%

-Jessica

-->Marketing - 10%

-->Sales - 70%

-->Magic - 20%

Is this possible?

Thanks!

James Garfield · Accepted Answer

So on a single record do you have 3 different areas for them input the product blend or how exactly are you storing this information?

You could do it as simply as creating 3 different Report formulae if they are all on the same record

Object.Marketing__c:SUM/(Object.Marketing__c:SUM+Object.Sales__c:SUM+Object.Magic__c:SUM)

Object.Sales__c:SUM/(Object.Marketing__c:SUM+Object.Sales__c:SUM+Object.Magic__c:SUM)

Object.Magic__c:SUM/(Object.Marketing__c:SUM+Object.Sales__c:SUM+Object.Magic__c:SUM)

Greg Annunziata · Answer

Thanks again James! That looks like it should work.

Reports & Dashboards