Data as column (Table)

[Anonymous]

Hello!

Is possible, turn some years as Columns?

I tried, but it failed.

Thanks !

[Anonymous]

The problem is :

-I have only 1 field as Dimension : Year

I dont have another Field to use as "Customer". So, i cant use the actual expression as Dimension, because i have 2 distinct expressions.

[MK_QSL]

Let me have your expressions...

[Anonymous]

=(count({<Segmento=(p ({$<Marca={'CHEVROLET'}>} Segmento))>}Numero_Chassis)/Below(count({<Segmento=(p ({$<Marca={'CHEVROLET'}>} Segmento))>}Numero_Chassis),-1))-1

=count(Numero_Chassis)/Below(count( Numero_Chassis),-1)-1

[MK_QSL]

have you got year field in your database?

[tobias_klett · Accepted solution]

Hello
got to chart properties > presentation and mark "horizontal"

[Anonymous]

Yes !

Any idea?

[Anonymous]

Thank you !!!!

It worked !

[MK_QSL]

Create a Straight Table...

Don't keep any Dimension

Expression 1

=(count({<Year = {'$(=Max(Year))'},Segmento=(p ({$<Marca={'CHEVROLET'}>} Segmento))>}Numero_Chassis)/Below(count({<Year = {'$(=Max(Year))'},Segmento=(p ({$<Marca={'CHEVROLET'}>} Segmento))>}Numero_Chassis),-1))-1

=count({<Year = {'$(=Max(Year))'}>}Numero_Chassis)/Below(count({<Year = {'$(=Max(Year))'}>}Numero_Chassis),-1)-1

Same way use Year = {'$(=Max(Year)-1)'} and Year = {'$(=Max(Year)-2)'}