Filtering Nested Line Items

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.

romain_brabantvila_0-1636122068547.png

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.

romain_brabantvila_1-1636122122204.png

 

It would be nice if we could pivot a module this way

romain_brabantvila_2-1636122210520.png