displaying only high level although calculations needs to be done on a lower level without display

[lmonincx]

Hi

I am looking for a way to put an if statement on a dim level and then display a table only containing a higher level but still applying the calculation on the lower level

Group Prod Amount

A Bike 150

A Motor 200

B Plane 400

I would like to display on Group level the sum of amount which is on Prod level > 170, it needs to be a straight table having only Group as a dim and an expression

THis mean for group A to report only 200

Any idea how to accomplish this in QV?

See attached qvw

[vidyut]

Change the expression in the second chart to sum(If(Bedrag>=200,Bedrag)) , That will do.

[lmonincx]

Hi, that worked in this small example, but in the actual application it's not just a number like <= 200 but a calculation, I can't get it to work there, can you have a look please?

it's the meaning that the measure 56,50 is going to be displayed in the lower table for Volume E.

Many thanks!

Linda

[vidyut · Accepted solution]

Hi,

I tried the following expression:

sum(aggr(IF(Sum ([Omzet inkoop bedrag]) > Sum ([Advies Minimum Aantal]*[Actie Inkoop Prijs]), 0, Sum ([Advies Minimum Aantal]*[Actie Inkoop Prijs])- Sum ([Omzet inkoop bedrag])),Artikel,Winkel))



and it gives 56,50 for Volume O, and not for E. Please check

[lmonincx]

Hi,

You are right the measure belongs to O and not E, thanks this realy helped me

Kind regards,

Linda