Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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!
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
This I have made - but my Calendar has only one field: #DATE
In the cross table I have one field per month
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!
Add a new line to script in calendar table.
Date(monthstart(#DATE), 'MMM-YYYY') AS MonthYear
Thanks - this works!