Line Item Subset Formatting

Line Item Subset Formatting

This post is a bit of getting ideas to work around but also see if people are experiencing similar issues.


I think it would be a good idea if Line Item Subsets could inherit the formatting and time settings from the source modules that they come from.


In the situation where you had a KPI which was a %, a number and a currency value, these could be split into 3 separate line item subsets and presented on the same dashboard. This will take up more space as the data will be coming from 3 separate modules. They will also need to be manually maintained for which lines go into each subset if a new line item is added to the source module.


Similarly for time settings, in a situation where a source module has a balance sheet movement that might have an opening balance, some movements which are summed over time, a closing balance and also an average balance. These would also need to be split into separate modules with similar problems as above.


This becomes a bit of an issue when trying to do version variances without using a native version formula. In a roundabout way, an idea of version subsets may also be a useful solution as the variances are only present in the modules where required and not in any input modules.

Super Contributor
Status changed to: Your support is needed
Master Anaplanner/Community Boss

Amazing how often I come on here and think, yes, why didn't I put this down already!

Would make using line item subsets a real game changer rather than modules with a load of line items on it.

Certified Master Anaplanner

Yes, @AndrewHall this is a feature that would have much value.  

Certified Master Anaplanner

Every single customer asks this first time you show a simple variance report build with line item subset. Why doesn't it show the same format?

And on you go building again several "intermediate" modules with mappings and lookups just to get the formatting right. Would be fantastic if this is solved! 🙂


Going through the pains of not having this feature available right now. Inheriting the original line item formatting would be a big win!


As Dan notes - same here. This feature would be invaluable.

Frequent Contributor

Yep - much help is needed with LISS as per another posting of my own.  LISS is Anaplan best practice yet Line Items look far better.  If LISS is the first thing a new user sees then they may be less than impressed.


Help needed

Frequent Contributor

This posting has 32 Kudos yet status is still "Your support is needed"  🙂

New Contributor

I would also suggest the ability to format grids in UX, that may be easier to develop and provide a workaround for this

New Contributor

Either the ability to overwrite column/row formatting in the UX or inheriting LISS formatting would be a huge win!


Surely being able to select a line and set it to % or similar in the UX is similar enough to setting conditional formatting?