Set analysis not working like it should

[#1]

Hi,

Can someone explain my why adding the TYPE in the pivot table makes the formula below not work anymore.

Sum({$<TYPE={"Dmtthjs"}>} [Sal Serv Other])

Can anyone help me to get it to work again?

The idea is that I can reuse the value of TYPE='Dmtthjs' for the other values of TYPE.

Yqtqanj

Dmtthjs

Sxrddvf

Kind Regards,

Dion

[lironbaram · Accepted solution]

hi

in this case you cant use set analysis because it select one type so in the other types it gives you null

check the attach file

i changed the expression to if clause