I have a table with monthly data. Every month a new month is added and the oldest is dropped. It covers 24 months. I now need a view of this data on a quarterly base, showing only full quarters per year (in a seperate table). Because of the moving nature of the monthly data i have no idea how to do this and would appreciate your help. The headers for the columns are formatted as dates: 2012/sep.
Above a small sample from the monthly view. So for 1st row the quarters would be: 2012 Q1 to Q3. for the second row only 2012 Q1 and Q2. 2011/dec is only a partial so not visible in quarter view, same for 2012/oct and missing data data in row 2.
And this is what the (as a result also moving) quarterlies would look like. At most 8 full Q's are possible. 3 months to a quarter.