i have a problem with regards to my source. how can i load this so that i will only have a moth field instead of jan, feb mar etc..
see attached file
You need to do a cross table. Use script below
CrossTable(Month, Val, 5) LOAD Field1, Field2, Field3, Year, Field4, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 FROM C:\Downloads\forums.xlsx (ooxml, embedded labels, table is Sheet1);
Retrieving data ...