Hi,
I am trying to get Qtr wise sales from Year and quarter column.i have few columns containing Sales, year, Quarter.I am trying to get quarter wise sales using Year, quarter & sales columns.If sales is 300 year is 2009 and Quarter is 3rd then it should value 300 in Q3 of 2009. IF year 2010 then it should give in Q3 of 2010. There are different quarterly sales for each region.
Thanks
Dee
I am trying to get Qtr wise sales from Year and quarter column.i have few columns containing Sales, year, Quarter.I am trying to get quarter wise sales using Year, quarter & sales columns.If sales is 300 year is 2009 and Quarter is 3rd then it should value 300 in Q3 of 2009. IF year 2010 then it should give in Q3 of 2010. There are different quarterly sales for each region.
Thanks
Dee