PIVOT - FILTER ONE DIMENSION BUT SHOW IN ALL

[safahsc]

Hi,

I'm new to qliksense. I have dimension "X" on my pivot table. And I'd like to filter my dimension in measure set expression but show the outcome in all rows.

NOTE: XYZ is a variable.

I try  (SUM({<A= {'XYZ'}>}  CARDS)  or (SUM({$<A= {'XYZ'}>}  CARDS) but pivot rows are filtered only for  row A.

Assume that (SUM({<A= {'XYZ'}>}  CARDS) = 10, I want table like this;

A 10

B 10

C 10

but I get;

A 10

Thanks for help.

[Vegar]

try using TOTAL:

SUM({<A= {'XYZ'}>} TOTAL  CARDS)