Pivot table - Dynamic values

[#1]

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

[#2]

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

[stigchel · Accepted solution]

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%') )