+ Start a Discussion
SeaTecSeaTec 

Percentage calculation

I need a report that calculates the % of opportunity type cross sell (custom field)/total opportunities grouped by order book date (Calendar Month) and Type(custom field)

 

I have the % calculation done but I only want to show the %  for one particular  opportunity type.  I can't however filter for that Type in the criteria area because then I wont have the total record counts to calculate my % with. 

SO right now I have

The results of the  report need to be displayed in a Dashboard Table  grouped per month.

 

Any useful tricks I can apply here?

 

Thank you

Pradeep_NavatarPradeep_Navatar

In my opinion there is no way to show total number of records if you filter report with Type field. You need to create a custom VF page to achieve this functonality.