How to pivot the data of rows into columns

[#1]

Hi All,

I have a table where data will be like

But i want my data to be like

Location Num      Week       Sales

3013                  week1         2448

3013                  week2         2513

3020                  week1         3957

3020                  week2          3673         

And so, on .I have attached my QVW. Can someone help me with any suggestions ?

Thanks         

[gmoraleswit · Accepted solution]

Please see attached file

[gmoraleswit]

You deleted the 'key' field on the calendar table

[gmoraleswit · Accepted solution]

Store the calendar table in a qvd:

store Calendar into Calendar.qvd;

DROP Table Calendar;

Calendar:

LOAD *,

  num(FiscalYearId & num(FiscalMonthOfYearId,'00') & num(FiscalWeekOfMonthId,'00')) as key

FROM

Calendar.qvd

(qvd);