Time Levels and Time
Hi,
We have weeks as base time unit and use all 3 time levels, i.e. Fiscal Year, Fiscal Quarter, Fiscal Month to segregate data in worksheets. However I have noticed that when I use all three time levels - Fiscal Year, Fiscal Quarter, Fiscal Month together with Time in worksheets data gets displayed properly. But When I use only two time levels, Fiscal Quarter, Fiscal Month with Time, data is not displayed in proper sequence. It gets jumbled up within quarters, e.g it shows in order: Q2-2013, Q2-2014,Q3-2013, Q3-2014.
If I use only Fiscal Month and Time again its not displayed properly. It shows in order: P2-2013, P2-2014, P3-2013, P3-2014.