Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Amy Goldberg will be --------------
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.
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.
Sunny's solution is spot on. Refer this Replace value in dimension of straight table with *** for code example.
thanks,
Thanks Sunny
You already thanked me once before, again?