Rank

[tyagishaila]

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

[hic]

Rank( ... ) will give you the rank within each store

Rank( total ... ) will give you the rank of the whole list.

HIC

[Anonymous]

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

[MK_QSL]

Create a Pivot Table

Dimensions

Store

Item

Expression

if(rank(sum(Sales))<=5,sum({<Store={"=rank(sum(Sales))<=5"}>} Sales))

[tyagishaila]

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

[Anonymous]

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