Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to display the values dynamically in pivot table based on condition. if value is 0 then 'Yes' and if value is 1 then 'No'.
Please help
I have used this expression
if(SecondaryDimensionality()=1,if(Value=1,'Yes' , if (Value=0,'No', sum(Alt(Value,0)), num(sum (Alt(Value,0))/count (MYSTERY_SHOPPER ),'0%') )
I am getting the below. Pls advice
Check your brackets, if I see it correctly you're missing a closing bracket after
if (Value=0,'No', sum(Alt(Value,0))
so:
if(SecondaryDimensionality()=1,if(Value=1,'Yes' , if (Value=0,'No', sum(Alt(Value,0)))),num(sum(Alt(Value,0))/count (MYSTERY_SHOPPER ),'0%') )