Condition on Overal Result (which is a calculated 12 month avrg)

[Former Member]

Hi Bex Gurus,

I got a report where I need to display all materials which got a low 12 month average shipment figure e.g. 12 month shipment average is about 100 units

However not the materials should be displayed but also the shipments of the last 12 months per month.

To see if dispite a low average the material is "active" -> season product.

Is there a way to accomplish this?

If I define calculating the result of shipments (accorss calendar months) to be calculated as average I see the correct average in the result column. However, I canno't place a condition on just the result column -> still shoing up the single shipment columns.

Any ideas?

Best regards,

Axel

[Former Member · Accepted solution]

Hi Axel

You can create a replacement path variable on Material restricted with another query (say query B) - The query B would have the material and the total/average amounts (as required), in this query B you can then place the low/high condition on the key figure amount as required since you cannot restrict the overall Result row in the original query.

The materials in the original query would be then restricted by the output of this query using the replacement path variable.

Hope this helps.

Regards,

Ninad