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

Graphs - Pipeline, Closed, Closed + Pipeline

When I set up a report to group by "Forecast Category", I get lines for "Closed", "Pipeline" and "Omitted". What I want are lines for "Closed", "Pipeline" and "Closed + Pipeline". I see that "Closed + Pipeline" is available in the "Select Columns to Total" section and I can group by "Closed + Pipeline" (not that grouping by "Closed + Pipeline" is helpful).


Is there a way to get the report to look like:


Closed + Pipeline ________________


Pipeline ____________________


Closed ____________________

Steve :-/Steve :-/

You may have to create a custom Formula(text) field that evaluates the Forecast Category and the Opportunity IsClosed/IsWon fields and run your reports on that. 


We had to do this on our SFDC Org because the standard SFDC Forecast Categories did not accurately map to the criteria our Execs use for Pipeline Categories.  So I wrote a formula that evaluated IsClosed, IsWon, Probabilty% and a few other things, and spits out "Pipeline Category 1, Pipeline Category 2, Pipeline Category 3, etc...). 



I'm not sure what you mean. Would you show me a sample of code?
Steve :-/Steve :-/
No problem, but I'm on the East Coast (6:30 PM Friday) I'll try to have it posted for you Monday
Thanks! I appreciate your help! :smileyhappy: