Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my pivot table i should show the months from Jan to Dec and also Quater's Q1, Q2, Q3, Q4
but when I select Janaury month the data in the Q1 is only showing Jan data but I should see all the three months data
and also for the the other Q2,Q3,Q4 for this one how should we write the Expression
Not sure what you have in your script, but something like this can help.
Quarters:
LOAD * INLINE [
Month, Quarter
1,Q1
2,Q1
3,Q1
4,Q2
5,Q2
6,Q2
7,Q3
8,Q3
9,Q3
10,Q4
11,Q4
12,Q4
];
Bill