Hi,
I don't understand waht exactly you want, but I've used the following solution:
Data_Table:
LOAD
"Date",
Year("Date") as Year,
Month("Date") as Month,
Value;
SQL SELECT
"Submit_Date",
"Value"
FROM "table1";
Quarters:
LOAD * INLINE [
Month, Desc, Order
1, Q1, 1
2, Q1, 1
3, Q1, 1
4, Q2, 2
5, Q2, 2
6, Q2, 2
7, Q3, 3
8, Q3, 3
9, Q3, 3
10, Q4, 4
11, Q4, 4
12, Q4, 4
];
I hope this help you.
Best regards.
