Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've 3 columns Product, region, sales...For each product there is sales in diffrent regions. I've one 1 region which is Europe let's say..... In my top 5 sales for the region....I always want Europe to be there. So if i make select any product it shud show me Europe + other 4 regions even if Europe is not featuring in top 5.
Try as calculated dimesion:
=If(aggr(Rank(Sum({<Region-={'Europe'}>}Sales)),Product) < 5 or Region= 'Europe' ,Region)
It gets the top 4 exclusive Europe and then adds Europe to the top 4.
Try as calculated dimesion:
=If(aggr(Rank(Sum({<Region-={'Europe'}>}Sales)),Product) < 5 or Region= 'Europe' ,Region)
It gets the top 4 exclusive Europe and then adds Europe to the top 4.
Thanks Gysbert i managed to get this one rite....... thanks for replying.....ur answer is correct......