expression to calculate only one row

[Anonymous]

I have the following information on excel sheet:

I need to calculate the sum of (Device + DHL + Clearance) like the following:

sum([Qty]) for (Device + DHL + Clearance) row only

[MK_QSL · Accepted solution]

SUM({<Category = {'Device + DHL + Clearance'}>}Qty)

Edited : Forgot to add measure Qty

[ahaahaaha]

Hi Rolf,

May be

Sum({<Category={'Device + DHL + Clearance'}>}Qty)

Regards,

Andrey