Pivot conditional formatting multiple levels - format selected columns
Can anyone advise if it is possible to give conditional formatting only to the 1 of my column levels if there are multiple levels?
I have the following columns:
Level 1: account (sales and ebit)
Level 2: scenario (act, bud, forecast, and variance to bud and forects
It seems i can only filter based on account, so it filters everything, but i only want the variance filtered.
I actually also tested if i switch the levels, (level 1 scenario and level 2 account), and I was able to filter again only based on account.
I checked the model also, I'm not able to select conditional formatting for some columns while disabling it for others...
See pictures attached
Thanks for any ideas!