Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I send you an example, I hope to help you