Number of opportunities in opportunity product revenue
Hi Champs,
Is there any way to refer # of opportunities in opportunity product revenue history subject area? I know we can use count(distinct(opportunity Id) but this will not work with FILTER function.
as you are aware Filter function will filter a metric field using a condition and it can be used to separately display a metric count without disturbing the main filter of the report.
I am doing a combined analysis where i have already filtered the # of opties based on a report level fitler. In the same report, i also need to filter # of opties based on another filter without affecting the main filter. but the FILTER function doesnt recognize count(distinct(opportunity Id) as a metric.
Is there any way to refer # of opportunities in opportunity product revenue history subject area? I know we can use count(distinct(opportunity Id) but this will not work with FILTER function.
as you are aware Filter function will filter a metric field using a condition and it can be used to separately display a metric count without disturbing the main filter of the report.
I am doing a combined analysis where i have already filtered the # of opties based on a report level fitler. In the same report, i also need to filter # of opties based on another filter without affecting the main filter. but the FILTER function doesnt recognize count(distinct(opportunity Id) as a metric.
0