pivot table,action to change column data

[everest226]

hi i have a pivot table in which in one column i have employee name, my requirement is that i have to create a bottom or text object thats says hide name so when i click hide name   the all employee name inside my pivot table must be ---------------    dash dash.

julien.frechet‌

Amy Goldberg    will be      --------------

[sunny_talwar · Accepted solution]

May be create a variable and use an expression like this:

If(vVar = 1, [employee name], '-------------')

and assign button action to toggle the variable vVar between 1 and 0.

[msdeepak]

Sunny's solution is spot on. Refer this Replace value in dimension of straight table with *** for code example.

[everest226]

thanks,

[everest226]

Thanks Sunny

[sunny_talwar]

You already thanked me once before, again?