Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd like to create a line graph with 5 measures, one for each of the current top sales people.
Number 1,2,3,4 and 5 performing salesperson sum([Sales])
based on [Current Report Flag] = {1}, [Product] = {"$(vProductSelected)"} , [Marketname] = {"$(vMarketSelected)"}
My Rank set analysis is not working.
The code that is not working is (Example for the #3 position)
=SUM({<[Salesperson]= {"=Rank(
Sum({$<[Marketname] = {"$(vMarketSelected)"},[Product] = {"$(vProductSelected)"},[Current Report Flag]={1}>}[Sales])
)=3"}, [Marketname] = {"$(vMarketSelected)"},[Product] = {"$(vProductSelected)"}
>} [Dollar Sales Share])