I have Plant, Material, Vendor and total Amount in cube level.
The user want the report output based on same Plant and Material across all vendors. Please see the below screenshot and suggest.
The requirement should be achieved at query level not at transformation level.
Thanks and regards