Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
not clear, what you wish to achieve,
can you also post the desired result?
Peter
Hi i am aching a sample with my data and result which i need....
You need output as below only two rows?
Class | A | B | C | D | E | F |
Sum(data) | 3691 | 8005 | 1151 | 1801 | 1141 | 200 |
with other filters
Can you upload sample QVW
Is it something like (with offset)
LOAD Metel,
Algeria,
Del,
Calcata,
Data AS R1, // or [Class A]
Data1 AS R2, // or [Class B]
Data2 AS R3,
Data3 AS R4,
Data4 AS R5,
Data5 AS R6
FROM
[....\sample (3).xlsx]
(ooxml, embedded labels, header is 3 lines, table is Sheet1);
Or do you need to have the data normalized (CROSSTABLE)?
Peter
yes i need it normalised....
this way?
CROSSTABLE (Class, Data, 4) LOAD Metel,
Algeria,
Del,
Calcata,
Data AS R1, // or [Class A]
Data1 AS R2, // or [Class B]
Data2 AS R3,
Data3 AS R4,
Data4 AS R5,
Data5 AS R6
FROM
(ooxml, embedded labels, header is 3 lines, table is Sheet1);
Peter
Hi,
The scenario you have mentioned isn't very clear, Can you post another excel sample where you have on 1 sheet the original data (or sample) then on the next sheet the transposed table you would expect, then on another sheet the cross.
As the saying goes, a picture paints...