Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i want to top 10 customers in stright table [not through dimension limit tab]
thanks
sony
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)
Hi Sony,
1. what are you asking? I cannot understand...
2. ok, but why you don't want to use the dimension limit?
Simone
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?
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)
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
thanks sir it worked.