Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
Your are using four qualifying fields,
CROSSTABLE(Month, MonthValue, 4)
crosstable creates text values as months.
you might have to left join "real " months afterward.
regards
Marco