Hello,
Can conditional formatting be done only on Line items?
I need to apply it on Columns which are Quarters.
How best can I do that?
@hema.murali ,
Sadly, conditional formatting can only be done on line items, so hoping you don't have a lot of line items. So, I used my SYS Time Filter module to determine if the period is a quarter:
In my module, I have a conditional formatting line item with the following formula: IF SYS Time Filter.Quarters Only THEN 1 ELSE 0 with the summary with Formula
Created 3 different conditional formatting rules, all based on my line item Cond Format
For a final look of:
Hope this helps,
Rob
Vote for this idea to help with the efficiency
using a different line item to format multiple line items
https://community.anaplan.com/t5/Idea-Exchange/Conditional-Format-using-line-items-from-another-module/idi-p/44191
David
@DavidSmith thanks for highlighting the idea! Voted for!
I want to track the Opening balance, drawdown, and ending balance for the following specific dates. I created the following dates in General List. Then I created the following module to track the balance, which there is a line item called Beginning balance which is the previous value of the Ending Balance. Draw/Repayment…
Just curious :)…
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…