months in the columns rather than in the rows

[miriambb]

Good morning,

I am trying to create a table similar to picture  1 in which the months are in the columns. However, in the new model, I have a fact table as a calendar and the months are in rows (picture 2), and I would like to have them in the column, any idea how I can do it with a table rather than a matrix?

Thank you in advance

Picture 2                    Picture 1
Picture 2Picture 1

[AntonioM]

Hi @miriambb,

A Matrix is going to be the easier way, is there a reason you're not wanting to use one?

To get that in a table you'd need to create a measure for each month and add them all in to the table. However, you wouldn't be able to dynamically filter the columns (such as by year) and you'd have to add a new measure for each new month.

[miriambb]

Hi Antonio!

Thank you for your help!

I actually managed to do it with a table and flat the hierarchy and now as a Matrix

Thank you for your helo!

Miriam