Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I have this qvw where I show sales by Name ranking depending on the year/quarter selected.
It works but I need to have the option to select just one Name and show like this:
Name: John
Rank: 4
Direct: $580,000
Reinsurance: $ 630,000
Considering that Rank is based in the Sales like the dinamic table on the right
And Considering that Direct and Reinsurance are the 2 vales for Type dimension
I´ve already created a separeted variable called vName
Like this?
Check attached
I had no idea that multiplying like this would work. Can you tell me why?
Avg(1) = 1 for the dimension which are selected and Avg(1) = 0 making the dimension value 0 for those rows which are not selected. This solution is a quick and efficient alternative to using an if statement...
If(Sum(Sales) > 0, Sum({1<[Reporting Calendar Year]={'$(vYear)'},[Reporting Calendar Quarter]={'$(vQuarter)'} >} Sales))
Here Sum(Sales) = 0 where the name is out of selection while Sum(Sales) > 0 for things that are selected.
Does this help?
Best,
Sunny
Yes, thank you so much!
No problem at all