Pivoting with more than 3 rows


Description of the enhancement required:

Need to be able to pivot more than 3 rows


How would it help their business process:
Reporting many cases of views needed with multiple dimensions with more than 3 lists in rows.

Most recent case
1) A module with many dimensions
2) Need to be imported to a flat list
3) Filtering before import needed
4) Impossible to do with all the dimensions, as not all the dimensions are in lines.
5) Column filtering does not work well

80 votes

In Review · Last Updated


  • Status changed to: In Review
  • chp127



    Is there any update on the expected release of this functionality? 




  • hi @AnaplanIdeas 


    Any update on this? It would help us also greatly to have more than 4 lists in rows. In my case, I made a matrix to select cost centers, accounts & subaccounts by entity -> i cant filter to the combinations that are valid.


    We would use this in our cost center planning model to enable user to select which cost centers, accounts & subaccounts combination they want to see, otherwise showing all combination would be just too much. 




  • Encountering this limitation as well when attempting to create filtered views to facilitate model to model data transfer.  Have found work arounds using multiple saved views but would be ideal if we could natively include at least 4 dimensions within the rows. 

  • Is there any update on this future? 

  • This is a fundamental feature that is needed in the platform. We very often move data from a multi-dimensional module in a spoke model to a flat module in a data Hub. Source modules in this context often have 4-6 dimensions that all require filtering to get an efficient export time. But because of this limitation, we can't achieve it. As @Tiffany.Rice points out, you can create many views BUT this only works in limited context. I would argue there isn't a reasonable workaround for this lacking feature with large multi-dimensional requirements.

  • zafkamar

    Hi all, I have a solve for this - please DM me.

  • jepley

    Agreed this is needed. Particularly for basis of importing— workarounds exist but are cumbersome and shouldn't be necessary.

  • Very Much Needed Function, Any Update From Anaplan?

  • FrankPau
    edited February 5

    @Jonathan.Liang or anyone else, pls let me know if there is any Anplan news for improviing this limitation! Thanks :)

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!