Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create filter based on rank of measure .
eg I want to provide the rank buckets as selection in filter
Top 10 Materials,Top 11-20 Materials,Top 21-30 Materials .
Expression for Top 10 is as follows :
if(sum(aggr(rank($(vWMAPEtotal)*100 *sum(
Aggr($(vDerivedErrorValue),[Country key TEXT],Material,[Forecast Accuracy Period],[Profit Center]$(vRadio_Button)))/
sum( total Aggr($(vDerivedErrorValue),[Country key TEXT],Material,[Forecast Accuracy Period],[Profit Center]$(vRadio_Button))))
<=10,[Material Code]))
,
'TOP 10')
However as sum is used ,it is giving an error.Also only putting aggr is giving incorrect result.
How can i implement this correctly ?
Hello, have a look at the sample App attached and let me know if it's what you were looking for ✔