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.
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.0
Yes, @AndrewHall this is a feature that would have much value.0
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! 🙂1
Going through the pains of not having this feature available right now. Inheriting the original line item formatting would be a big win!0
As Dan notes - same here. This feature would be invaluable.0
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.
This posting has 32 Kudos yet status is still "Your support is needed" 🙂0
I would also suggest the ability to format grids in UX, that may be easier to develop and provide a workaround for this0
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?0
It would be great to have the prefix/suffix in New UX boards/worksheet like management reporting format where one can put prefix/suffix easily in format option. It would greatly reduce the modelling efforts, especially when using LIS we will have to bring the percentage values in text format as a workaround to display in %age values.0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!