Adding measure in filter pane

Iwin — Wed, 02 Mar 2022 13:23:15 GMT

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 ?

Re: Adding measure in filter pane

Andrea_Spinetti — Fri, 01 Apr 2022 10:14:36 GMT

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

topic Adding measure in filter pane in App Development

Adding measure in filter pane

Re: Adding measure in filter pane