How to use function to show the value in cross sheet?

[CongqiangWang]

as the picture showing, this is a cross sheet that shows the [TM] & [Status].

[TM] has "ER",''KR'' 2 values, [Status] has "A590",''R100'', "R400" 3 values, and the numbers shows the [qty].

[qty] is a measure value, [TM] & [Status] are all dimensions.

Because I don't need this cross sheet in the final report, so I write a function to show the  different [qty].

e.g. =[qty] where([TM]="ER" and [Status]="R400")

From the cross sheet, this function should show the result "27", but it doesn't work.

So could you help me to solve this probelm?

(right function sentence or another way to show the cross sheet value)

thank you very much.