stright table

[soniasweety]

Hi All,

Olivier GAUTIER

i want to top 10 customers in stright table  [not through dimension limit tab]

thanks

sony

[simospa]

Hi Sony,

1. what are you asking? I cannot understand...

2. ok, but why you don't want to use the dimension limit?

Simone

[soniasweety]

i want to dispaly top 10 customers in the table

if i use dimension limit tab it is not giving exact  10 bcz i  have 3measures

i think that is the reason

so how can i achieve this?

[Anil_Babu_Samineni · Accepted solution]

Try this?

Measure1:

Sum({<[Type]={'Hw'},[Name]=$::[Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Measure2:

Sum({<[Type]={'Sr'},[Name]=$::[Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

Measure3:

Sum({<[ Name]=$::[ Name], Customer={"=Rank(SUM(Amount))<=10"}>}[Amount])/$(vFormat)

[ogautier62]

Hi,

Sony,

do you want top 10 total sales and then the 3 measures (if so Anil's solution)

or do you want for each selection top 10 in it ?

regards

[soniasweety]

thanks sir it worked.