cross table

[tincholiver]

hi everyone,

I don´t know how solve this:

mi table:

DATE	CAR	Quant
202107	AUDI	4
202107	HONDA	9
202107	FORD	129
202108	AUDI	3
202108	HONDA	7
202108	FORD	116

mi desired table:

DATE	AUDI	HONDA	FORD
202107	4	8	129
202108	3	7	119

ideas? thank a lot

[AshutoshBhumkar]

Hi, 

You'll have to use separate measure for each CAR in straight table.

Measure for AUDI : Sum({<CAR = {"AUDI"}>}Quant)

and 2 more for other Cars.

Or you can use Pivot table :

Thanks,

Ashutosh

[tincholiver]

hi @AshutoshBhumkar 

i need to load desired table in script not in graph

[Saravanan_Desingh · Accepted solution]

Try this,

tab1:
Generic
LOAD * INLINE [
    DATE, CAR, Quant
    202107, AUDI, 4
    202107, HONDA, 9
    202107, FORD, 129
    202108, AUDI, 3
    202108, HONDA, 7
    202108, FORD, 116
];

[tincholiver]

thanks @Saravanan_Desingh 

works perfect!!