Data as column (Table)

[Anonymous]

Hello!

Is possible, turn some years as Columns?

I tried, but it failed.

Thanks !

[Anonymous]

Load your table as Cross table

[#3]

Create as a pivot table, then drag the dimension up as a column

[Anonymous]

I tried, but it stays like this.

[Anonymous]

I tried, but it didnt work.

I think i need expression as dimension. Am i right?

[MK_QSL]

What is the dimension and expression you are using?

[Anonymous]

Dimension i'm using 'Year'.

And expression, 2 var%.

You can see it in the image, in first topic.

Thanks !

[MK_QSL]

what's wrong ? what you expect and what you getting?

[Anonymous]

I need to have the year 2011, 2012, 2013 and 2014 as column. And expressions as lines.

But it's not possible just using Cross Table and drag it to the right place.

[MK_QSL]

Do something like  this.... don't know your exact column/Field name so giving suggestion using sample field..

Let we have Customer, Year and Sales as Field... You can use as below

Dimension

Customer

Expression

SUM({<Year = {'$(=Max(Year))'}>}Sales)

SUM({<Year = {'$(=Max(Year)-1)'}>}Sales)

SUM({<Year = {'$(=Max(Year)-2)'}>}Sales)

SUM({<Year = {'$(=Max(Year)-3)'}>}Sales)

Hope this helps...