I have this issue to show background color of a dimension based off value in another dimension. I have attached a sample file and hope it helps to explain my issue. The issue is that since I don't have rating in August for one project, so even it is a business only project (with value of 1 in Business column), the background color of Project doesn't get picked up and there's no highlight. Can anyone help on this case? Please feel free to ask if my statement above is not clear enough. Thank you in advance!
With a straight table, you can hide a column form the presentation tab. For a pivot table, it's a little more complicated. To hide an expression column you need to make it zero width using a one-time macro. You'll need to know the chart id from the properties general tab and which expression column you want to change (counting from zero) so #1 in your case for the second expression. Paste this macro code in the module editor (Ctrl-m) and press the Test button the in the editor. That's it.
REM You can't set a pivot table column to zero width from the UI. Use this macro to force the widths.
REM It only needs to be run once, not onOpen
Sub SetColWidthZero (id)
set chart = ActiveDocument.GetSheetObject(id)
set cp = chart.GetProperties
set exprs = cp.Expressions
' First expression is 0, second is 1, ...
' Set the expression# to change
Set expr = exprs.Item(1).Item(0).Data.ExpressionVisual
expr.ColWidth = 0