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.