Planning Data from Excel 2

[#1]

I have made a planning table in excel and put this to QV:

CrossTable(Jan, Data)

  LOAD F1,

       Jan,

       Feb,

       Mar,

       Apr,

       May,

       Jun

  FROM

  D:\Planning.xlsx

  (ooxml, embedded labels, table is Sheet1);

Now I want to link this with a calendar function. So I want to see in March e.g. I have 100 active subscription plan was 120.

Calender is a key in the subscription data and in calendar data. How could I link it now with the cross table?

[bruno_m_santos]

Instead of put months "Jan,       Feb,       Mar, " I suggest to use the first day of month 01-01-2013, 01-02-2013.

You can link them directly.

Thanks

Bruno

[#3]

This I have made - but my Calendar has only one field: #DATE

In the cross table I have one field per month

[salto · Accepted solution]

Hi,

please find attached my approach.

I have created a calendar and linked the Month field in the Calendar to the Month field from the Excel table.

Hope this helps!

[bruno_m_santos]

Add a new line to script in calendar table.

Date(monthstart(#DATE), 'MMM-YYYY') AS  MonthYear

[#6]

Thanks - this works!