I have one requirement like
user will enter one fiscal period say 009 2005
in report output he wants to display as beloww
1. 1st column will display quater 1 value means (janfebmarch)
2. 2nd column will diaplay Quater 2 value means (April+ May+ jun)
3. 3rd column will display YTD upto 2nd period value means (Q1+Q2)
4.3rd column will display Variance of Q2 and Q1
5. Column 4th , 5th, 6th will display individual peiod value menas value for july (4th column) , August (5th) , Sept (6th)
7. 7th column will display Quater 3 value means (JulAugSept)
8. 8th column will display YTD upto Sept value means (Q1Q2Q3)
9. 9th Column will dispaly VAriance between Q3 vs Q2.
if any one knows about this please try to explain step by step.