function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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


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.