Adding measure in filter pane

[Iwin]

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 ?

[Andrea_Spinetti]

Hello, have a look at the sample App attached and let me know if it's what you were looking for ✔