How to show all the value in denominator irrespective of dimension

[Rajkumar]

Hi All,

I am restricting the dimension by top 5 . Ex, out of 10 stores  restricting 5.

In measure i want to show 5 stores / total stores.

Currently i am able to get  5 stores / 5 stores. If I do restriction in dimension.

Please advise me

[lironbaram]

hi 

how do you limit it to the top 5 stores 

in general 

sum(Sales)/sum(TOTAL Sales) should work 

[Rajkumar]

if(aggr(rank(sum(sales)),store)<5 ,store) in dimension

[Rajkumar]

Any help would be appreciated ...

[tresesco]

Did you try Sum(Total sales) as suggested above? Isn't that working?

[Rajkumar]

I am using 100% chart .

1 st dimension is quarter 

2nd dimension is if(aggr(rank(sum(sales)),store)<5 ,store)

3 rd Measure is sum(total <quarter > sales)

When i am restricting top 5 store in dimension it showing 100 % of that 5 stores.

I want the actual  % of the store divided by total stores. 

Hope I make you understand ,Thank you

[Anil_Babu_Samineni]

please post some sample data set to work with you

[Rajkumar]

Please find the sample data.

[Rajkumar]

Hi Anil, 

I have attached the sample excel file.

[Prashant_Naik]

Hi Raj,

i have taken Quarter in 1st dimension, only Store field in 2nd Dimension and Measures as Sum(Sales)/Sum(total <quarter> Sales)

and restricted the dimension to top 3 as your data set has 5 values.

here is the attached image of value that i got(Capture 1) and the same i validated in excel(Capture 2).

Regards,

Prashant