i have a requirement to calculate exception aggregation on multiple characteristics .
PartNo has multiple toolnumbers
toolnumbers has multiple supplier numbers .
And then keyfigure values which are same for all records. Like below
partnumber - P1
toolnumber - T1 T2 T3
suppliernumber S1 S2 S3 S4 S5 S6
KF - 1111 1111 1111 1111 1111 11111 11111 1111
On bex query , i have Partnumber and Toolnumbers with keyfigure values .
here the values are getting aggregated since supplier number was not added to the rows.
I need to exception aggregate the keyfigure values with all the 3 characteristics . But i do not want to take suppliernumber in rows. Please suggest.