Display of Aggregation Values in Bex Analyzer!

[Former Member]

Hi Gurus -

Is there a way to NOT show the values of a field at the aggregated level?

As an example, I have a KF of Vendor Price. When I see the report at the total level, I dont want to see the values of Vendor Price. But if I drill down to the Item level, I want to see the Vendor Price. Please note the Vendor Price is for one item only.

I hope this makes sense. Any help would be greatly appreciated.

I played around in query designer and can hide the total value but the values at the Item level are also hidden.

Thanks!

[former_member184494]

Can you identify based on key or somehow that the given level is an aggregated one - then you could try having a formula variable with replacement path and then use an if condition in the formula instead to show 0 or no value at aggregated levels.

Arun

[Former Member]

Hi Arun -

Thanks a lot for the response.

I need a little help.

I createa a formula variable. Do I put the if condition in my formula variable? How do I use the replacement path here? I don't have any option. I might not be understanding how to accomplish this. Could you please provide me with a few steps! Thanks a lot!