I am trying to format the following pivot table, the column Metric2 has 3 values, Income, Balances and Margin. I want to be able to format such that it is easy to distinguish between the three of them.
Is there anyway I can add a horizontal black line that would go all the way across my pivot table to make it easier to distinguish between Income, Balance and Margin?
I think you want to do the Dimension background in this case, the help will guide you on what you need to do, hopefully that may do the trick.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.