Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
i have to load the budget which is in different files 2016.xls 2017.xls based on the year.
I have to link my budget using the Name (which is fine in the excel) and the period/year.
As you can see the column name are "2017/Jan" , "2017/Feb"
How i can use this information to be linked to my calendar with Name , Month and Year?
Thank you, any help is really appreciated.
Please share some sample data.
Something like below. Change field names accordingly.
CrossTable(YearMonth, Sales)
Data:
Load * Inline
[
Name, 2016/Jan, 2016/Feb, 2016/Mar, 2017/Jan, 2017/Feb, 2017/Mar
A, 100, 110,120,130,140,150
B, 200, 210,220,230,240,250
C, 300, 310,320,330,340,350
];
MasterCalendar:
Load YearMonth, Month(YearMonth1) as Month, Year(YearMonth1) as Year;
Load Distinct YearMonth, Date#(YearMonth,'YYYY/MMM') as YearMonth1 Resident Data;
Here some example of data.
Thank you for the support