Straight Table Columns

[anonymous1]

hi, 

im trying to create a straight table that has ITEM as a dimension, then each MONTH as an individual column, and sum(ITEM) beneath each of the months.  however, when i try this im getting the months being listed vertically.  i have a column MONTH with each of the months in it, is there a way to use each of the months as an individual column?

TIA

[petter · Accepted solution]

Yes you can create an expression for each month like this:

Sum( {<MONTH={'Jan'}>} Sales)
...
Sum( {<MONTH={'Dec'}>} Sales)

And if you have totals enabled for each expression and select the option to have the sum below you get what you want.