Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to define quarters for the months.From fiscal Year Apr-Mar.Apr is Q1.If any one of you have idea
about this pleas share with me.
Note
I trield also using inline wizard
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.