Calculate total amount for each product

[Anonymous]

Hello,

Could you help me to add expression, which calculate total sum for each product group by TYPE.

Please find attached the file.

Thanks,

[alexandros17]

first expression:

count

(DISTINCT [product ID])

second expression:

sum(Price)

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Sum(aggr(Count([product ID])*Max(Price),TYPE, [product ID]))

Hope it helps you.

Regards,

Jagan.

[Anonymous]

hello Jagan,

Why did you use Max(Price)? I removed Max and it works.

Thanks again,