Problem on dimension restriction to show the lowest value

[bimala0507]

Hi:

I am facing a typical issue in dimension restriction. I would like to see Top 10 materials which has largest price difference between 2013 and 2014 and similarly would like to show Top 10 Materials with lowest price difference and I would like to show irrespective of the selection. While it shows me Top 10 of largest price diff., but not showing the materials with lowest price difference unless I select the Year 2013. Attached my qvw files. Is there something I need to do to show the lowest value.

Appreciate a quick reply, as I am stuck up. Any feedback regarding this issue would be highly appreciated.

[sujeetsingh]

It will be better if you go for buttons which make select in field with all this limitings

[tresesco]

Try expression:

=Sum({1} $(v_netprice_2014) - $(v_netprice_2013))

[SunilChauhan]

use

-(Expression used in chart)  in sort Expression

hope this helps

[bimala0507]

Hi:

Thanks much. Surprisingly this works, but not able to understand, why MIN does not work.

[#6]

Are MATNR and Material No. are 2 different fields??

Because you are using MATNR in 1st chart and Material No. in second chart.

By using MATNR in second chart, its working fine.

Try this way.

[tresesco]

Min() doesn't work because of null/zero values. Go to presentation tab and uncheck 'Suppress Zero Values' and 'Supress Null Values'; you would see the output.

[bimala0507]

Thank you so much. Appreciate the explanation.

Kind Regards,

Bimala