Transpose the data of table and restrict to show latest 12 months

[#1]

Hi All,

Raw data
Sales	Month
171	Jan-13
412	Feb-13
480	Mar-13
333	Apr-13
282	May-13
124	Jun-13
430	Jul-13
192	Aug-13

and so on requirement is to show data in the transpose , and only latest 12 months should come. Excel file attached.

Please suggest!

Thanks

MV

[#2]

Hi All,

Data:

LOAD Sales, Month

FROM

C:\Users\Desktop\Month1.xlsx

(ooxml, embedded labels, table is Sheet1);

store Data into MyQvdFile.qvd;

NewData:

LOAD

Date((Month),'MMM-YY') as Max

FROM C:\Users\klrb099\Desktop\QV\Data\MyQvdFile.qvd (qvd);

Can we achieve this by storing data in qvd and then using qvt. I am not sure how to proceed.

Thanks

MV

[PabloOrtiz]

I send you an example, I hope to help you