Dates as Columns

[evansabres]

Hello -

My question concerns having dates (Months) as Field Names and the problem that presents.

My data appears as this:

Brand         Seat Level      Value        Jan    Feb     Mar    Apr   May    Jun   Jul   Aug   Sep  Aug Sep    Oct   Nov    Dec

Name         100 Level         100           11     24        99       88   6          44    11   2        9        6     33      100   999   9

Name          200 Level

Name          300 Level

This is how the data enters from my data source. I want to have the months as a dimension as opposed to each month being the name of a column.

Is there a work around for this?

Thank you.

[evansabres]

That was the issue, thank you. So now, the script works, however, when I re-load the application, 'Brand' is now part of months. (January - December) Any thoughts on why that would be occurring?

[swuehl]

Your are using four qualifying fields,

CROSSTABLE(Month, MonthValue, 4)

[MarcoWedel]

‌crosstable creates text values as months.

you might have to left join "real " months afterward.

regards

Marco