Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
how do you limit it to the top 5 stores
in general
sum(Sales)/sum(TOTAL Sales) should work
if(aggr(rank(sum(sales)),store)<5 ,store) in dimension
Any help would be appreciated ...
Did you try Sum(Total sales) as suggested above? Isn't that working?
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
please post some sample data set to work with you
Please find the sample data.
Hi Anil,
I have attached the sample excel file.
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