Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have list of Codes for a metric called Sales.
In a table I can put the rank of each code, based on Sum(Value).
Now I want to put the Sum(value) of the top1 into a text object.
But in my filters I have to select:
- Month Year;
- Code;
- Metric.
I want to show the top 1 value, ignoring the filter Code.
Giving you a context:
I have the above table, when I select Metric and MonthYear:
My top 1 Sum(value) is Code=1295.
So when I add a selection in Code = 604, I want to show in a text object the value of the top 1, corresponding to the filters I'm applying, except Code.
I've attached a qvw sample. Please see Sheet Rankings.
Thanks in advanced,
Sílvia
Got it. Thanks for that Sunny.