how to hide columns in pivot table but still use the expression in them for other columns
I have a pivot table sceenshot attached where I have added in columns at the end that I have used to calculate % of targets. I use these columns in the background colour of the columns that show red, amber, green.
my problem is that I need to hide the columns at the end showing the targets ie Target MH6 Column 5c 10% etc.
When I hide them using the conditional view =0 or =False() the background colour wont work for the other columns as the expressions seem to be hidden also.
Any help on how I can hide these last four columns and keep the colour coding.
Re: how to hide columns in pivot table but still use the expression in them for other columns
Its not possible to hide columns but keep their values in a pivot table. You can do that in a straight table with the hide column option in the presentation tab, but the pivot tables only have the conditional display option in the Expressions tab which hides the column and does not calculate the column.
If you make the columns as narrow as possible, with a space as a label and the text colour the same as the background colour, they will (almost) be hidden. You may want to turn off the vertical expression cell borders as well.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein