Skip to Content
Former Member
May 22, 2015 at 06:04 AM

Exception Aggregation logic


Hi Experts,

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.