Export View with 4 dimensions to the left side and time in the columns


Is there a way to export with 4 dimensions on the left side and time (months) in the columns?

I created a saved view and used tabular multiple column export (filtering the specific months with a boolean in a separate module). However if I put the line item and time in columns it errors stating line items must be in columns.

Best Answer

  • BrunoRodriguez
    edited May 2023 Answer ✓

    Hello @Esmee,

    The maximum amount of dimensions you can have is 3 as rows.

    If you want anything else you have two options:

    1. If the dimension is unique for each item in one of the lists, create a property in that list and export it as label.
    2. Create a staging list for the export - similar to the idea presented here, but just to concatenate the data. Rather than exporting the code, you could export the 3 dimensions concatenated as label too.


    Kind regards,

    Bruno Rodriguez