Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Anyone please tell me
Regards,
Devi.
You can use Rank Function instead of Dimension Limit
Dear Devi,
Prior to QV 11 you calculate the dimension
You can calculate a dimension on the dimension tab, the following will give you the top 5 sales dimensions:
Aggr(If(Rank(Sum(Sales))<5, 'Dim_Name', 'All Other Value'), Dim_Name)
Hope this helps, if you are still struggling please post a example.
Regards
R