Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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 ?
Hi @Iwin
Could you, please, better explain what you need to get?