use background color and text color to make it not visible in pivot table -- issue
Hi, hope someone might have come across this issue..
I have a pivot table with months as horizontal so cross-table - when I try to use the background color, text color for the dimension and the expression to make it NOT visible it is not working...
If you look at the below screenshot the first value 01/01/1907 is kind of dummy value to which I want to have it in pivot table but make it not visible... I have 5 dimensions , the 5th dimension is month which I drag it into horizontal