Filtering Nested Line Items
Today when we pivot a module, we can add list members, time, or line items to rows or columns. Although we can use both line items and a list as the column headers (or row labels) at the same time, the “Territory ID” line item in the screenshot is just a reference value that does not need to repeat for each member of the list.
What we would like to be able to do is to display additional line items or list properties so they show up only once, followed by list items as column headers. We know Anaplan can calculate the data this way since we can export files in this format, as long as we add the list property that the line item “Territory ID” references.
It would be nice if we could pivot a module this way
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!