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!

pivot_conditional_formatting_84127.png

pivot_conditional_formatting2_84127.png

pivot_conditional_formatting3_84127.png

Accepted answers

einas.ibrahim

@kinga.markovics

Great, I'm happy you got the help.
That's exactly what I was looking to see in the blueprint. I wanted to know if you were using native versions (can't be CF) or versions as line items.

Good luck

All comments

einas.ibrahim

Hi @kinga.markovics

Could you please share the blueprint of the module?

kinga.markovics

Hi,

I actually got help from Anaplan support related to this while we were talking about something else. According to them, versions cannot be conditional formatted - only line items.

So if i want to make it work for me, I have to create variance line items, instead of having them in versions.

Thank you for trying to help though 🙂

Regards

Kinga

einas.ibrahim

@kinga.markovics

Great, I'm happy you got the help.
That's exactly what I was looking to see in the blueprint. I wanted to know if you were using native versions (can't be CF) or versions as line items.

Good luck

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385