Cannot separate columns

I'm having an issue with calculated columns.

When I select a date in the slicer, i want two columns to show in my matrix: the selected date and the same period last year. I have calculated columns to do this, but when I select them, this is what happens:

see picture

Instead of having 2 columns, one stays above the other. Does anyone know why this happens? How can I change it?

Thank you so much in advance.

Sílvia

Upvotes: 0

Views: 50

Answers (1)

CR7SMS
CR7SMS

Reputation: 2584

It looks like in the "Matrix" Visualization, you have "abr2015" and "abr2014" in the Columns Section. Move them to the Values section and you should get what you are looking for.

Upvotes: 1

Related Questions