I need one help
Below are the details of my requirement
1. there will be one single selection for fiscal period say 0062005.
2. In the report display i want to display all period data in different different column.
3. and i also one to display Quater summary data in dif. column like quater 1 will be the addition of jan(001) + feb(002) + march(003) it will continue
4. each quater column will display every after three period column.
cloumn 1 = 001 data
column 3 = 003
column 4 = Quarter 1 = Jan + Feb + March
column 5 = 004
column 7 = 006
column 8 = Quarter 2 = April + May + June
column 9 = Variance Q2 Vs Q1
Quarter 3 = July + August + Sept
Variance Q3 Vs Q2
Quarter 4 = Oct + Nov + Dec
Variance Q4 Vs Q3
if any one knows about this please guide me with steps