Any object to use measure as a filter

Iwin — Thu, 03 Mar 2022 05:03:05 GMT

I want to use below measure to filter top 10 materials upon selection

sum(aggr(if(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
,$(vWMAPEtotal) *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))))
,[Material Code]))

As it a complex measure i cannot create at backend.Also tried using aggr but it is giving incorrect values.

How can i give the user top10 only on selection ?

Re: Any object to use measure as a filter

Andrea_Bertazzo — Thu, 10 Mar 2022 16:34:40 GMT

Hi @Iwin

Could you, please, better explain what you need to get?

topic Re: Any object to use measure as a filter in App Development

Any object to use measure as a filter

Re: Any object to use measure as a filter