Display of Aggregation Values in Bex Analyzer!

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!