Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am finding top 5 items
1. on the basis of whole item list
2. on the basis of items available at each store.
Suppose item A,N,O,R,S are top 5 items as whole and it may be possible item A,B,C,D,E are on top at Store1 and N,R,T,U,V
are on top at Store2.
How can I achieve this?
Thanks
Rank( ... ) will give you the rank within each store
Rank( total ... ) will give you the rank of the whole list.
HIC
Hi Shaila,
PFA file. Whatever requirement I could understand based on that I created it.Hope it is useful.
All the best.
Cheers,
Ritesh Pathak
Create a Pivot Table
Dimensions
Store
Item
Expression
if(rank(sum(Sales))<=5,sum({<Store={"=rank(sum(Sales))<=5"}>} Sales))
Thanks Ritesh,
My query is little bit different from your solution.
Actually first I want to find out top 5 items in overall business
and second at store level, it means at each store those 5 items are on top sale. this item list will different for each store.
Regards,
Shaila
Hi Shaila,
Your problem got fixed? If not, please send me some sample data in excel @ riteshpathak10@gmail.com and I will create a solution for you.
Cheers,
Ritesh Pathak