That was it. I am still using Office 2010. Works with my year/quarter calc but when I change back to the original version just calculating quarter, results for quarter 4 are wrong because the sample data crosses calendar years and includes two quarter 4 periods.
However, this still requires the 'helper' calculated column so not really seeing advantage.
|