Oracle Analytics and AI

ark86

Hi,

I want to make a report listing vehicles and salary of vehicles.

When i add Agent Name, Vehicle Name, and Salary, it repeats salary against vehicles as one agent has more than vehicles.

You can see the total is also incorrect.

How can i get following output?

Thanks.

[Deleted User]

Not sure this is even conceptually possible since "value suppression" means dimensional attribute value suppression and not measure suppression. It's a level-based measure in your case and will always be repeated. Because it's a measure.