Skip to Content
Aug 24, 2018 at 06:01 AM

exception aggregation on multiple characteristics

414 Views Last edit Aug 27, 2018 at 04:47 PM 2 rev

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.