Filter by Key Figure or Calculated Key Figure?

[Former Member]

Hi,

Is it possible to filter a report on key figure or calculated/restricted key figures? If yes, then how?

Here is an example of my problem:

I have a restricted key figure for invoice – that picks out the last invoice value between two dates (variable), for instance 2004-01-01 and 2004-12-31. Now, in my query I would like to EXCLUDE materials which don’t have any invoice values between those dates:

Now:

Material A 1000 USD

Material B

Wanted:

Material A 1000 USD

Best Regards

/Daniel

[former_member188975]

You can try using a condition using Material characteristic and Invoice RKF > 0. When active, this will display materials whose invoice value is more than zero.

[mstrein]

Hi Daniel,

you would use Conditions to achieve this! You can create them in the Bex Query designer.

Regards,

michael