I have a requirement that, I need some different behaviour of Aggregation in report level for the below datas in the cube.Vehicle Ind No Material Values A 1 X 100 A 1 Y 100 A 2 X 200 A 2 Y 200 B 1 X 300 B 1 Y 300 B 2 X 400 B 2 Y 400
Here, One Indent No will have one Value. The result in the report should be like.....Vehicle Values A 300 B 700
I had tried Exception aggregation with all the possiblities like, in the value with reference to info Object Ind no with first value, Last Value etc.
But Nothing is working.
I need your advice to achieve the above requirement.