Aggregation function under Multiple If conditions

[santhoo_san]

Hi

I am looking for different aggregation results for different line items in single table. I tried using multiple if conditions in the expression, but getting result only to the 1st line item. Can someone help me solving this. attached sample files.

Thanks,

Santhosh

[Gysbert_Wassenaar]

I see four different results, one for each conditional branch in your expression: