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.
The maximum amount of dimensions you can have is 3 as rows.
If you want anything else you have two options:
- If the dimension is unique for each item in one of the lists, create a property in that list and export it as label.
- 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.
Thanks @BrunoRodriguez !1