Aggregation in SSRS for same type of records

Finance and Operations/AX Developer Forum
1

Hi All,

Consider the following scenario.

ItemID Qty Unit Price Line Amount

Item A 10 100.00 1000

Item A 20 100.00 2000

Item A 25 200.00 5000

So following should be the output.

ItemID Qty Unit Price Line Amount

Item A 30 100.00 3000

Item A 25 200.00 5000

So actually the requirement is that my report should club the Qty and Line amount field for the same items having same unit price . I think a group by expression is required in SSRS but as it will be a conditional expression,i am a bit confused in that.

2

I don’t see any conditions there. It’s simply something like this (pseudocode): select sum(Qty), sum(LineAmount) group by ItemId, UnitPrice.

If you know how to use groups and aggregations, you shouldn’t have a problem.