Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use visual cues for text in a pivot table ?
e.g if a text item = variable value then show with visual cue.
go to pivot table properties->expressions tab->expand the expression you want to format->
under background settings put an if statment:
if(text='asdasdasd',rgb(...),rgb())
Dimensions have also background setting so you should be able to use the above logic if you want to format the dimension.
go to pivot table properties->expressions tab->expand the expression you want to format->
under background settings put an if statment:
if(text='asdasdasd',rgb(...),rgb())
Dimensions have also background setting so you should be able to use the above logic if you want to format the dimension.