Apply conditional format on Top Level Item

Hi all,

Can someone teach me how to apply the conditional format to only the Top Level Item?

Picture below is showing that I am trying to highlight the lines that that not equal to 100%(I have a line item with the equation that if total All Station is =1 then 0 else 1). But I only want to apply the condition format to the Top Level Item, which ic All Station in this situation. Can someone share some pointers on how I should approach with this?

Thanks,

Jim

Accepted answers

rob_marshall

@jimfeng5

Check out what @ChrisAHeathcote put together here:

https://community.anaplan.com/t5/Anaplan-Platform/Highlighting-Parent-Rows-of-a-List/m-p/86006#M19012

Rob

All comments

rob_marshall

@jimfeng5

Check out what @ChrisAHeathcote put together here:

https://community.anaplan.com/t5/Anaplan-Platform/Highlighting-Parent-Rows-of-a-List/m-p/86006#M19012

Rob

jimfeng5

Thanks Rob, that was a great start.
On top of what Chris had, I created additional line items so that I only highlight the % that are not equal to 100%, here is a screen shot of what I did:

My Conditional Format is based on "Test 3" line item, I will be trimming this module to reduce line items.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…