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

Esmee

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.

BrunoRodriguez

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.

Cheers!