Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimension State and created a variable let suppose $(v#Name)
In $(v#Name) is a set expression,according to this variable i want to show top 5 and bottom states value in straight chart.
=If(Aggr(Rank(Sum(Sales)) <= 5,seller),seller)
=If(Aggr(Rank(Sum(Sales)) >= 5,seller),seller)
its not working
use this in dimension =If(Aggr(Rank(Sum(value)) <= 5,state),state)
measure sum(value)
alraedy done this its not working no value ar e been displayed
sharing your work file might helps me alot
i cant share due to security reason
Just FYI, you can use the Settings\Document Properties\Scrambling tab settings to scramble any confidential fields in the data, that should negate the security concern I would think such that you can post a small version of things.
Regards,
Brett