Hi All,
I have the following set up where / separate's attributes - where Value X and Y can exists multiple times within a month linked to the Item ID.
Place / SubPlace / itemID / Year / Month / YYYYMMDD / ValueX / ValueY / SUMXPlace / SUMXSubplace / SUMYPlace / SUMYSubplace /
What i would like to do is after i have the sum per month per place and subplace, is to see the sum again of these sums on a quarterly basis - ie. Jan-Mar = Q1, April-June = Q2.
So the final table would be something along the lines of this - to still allow filtering per place/subplace/quarter
Place / SubPlace / Quater / QSUMXPlace / QSUMXSubplace / QSUMYPlace / QSUMYSubplace /
Any ideas or help would be greatly appreciated!
/Emma