Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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