0

I have this raw data: enter image description here

In the data the "Act" is actual number, "Fct" are forecasted, and I have to create a row called "Var" to calculate (Act-Fct). The "Cum" is the accumulated variance. The "Prev" refers to the previous year data and the"VarYOY" refers to the variance year over year (Prev-Act).

I am not sure how to get the "Var", "Cum" and "VarYOY" rows into the matrix. Any guidance or a sample solution would be what I'm looking for.enter image description here

maverick07281975
  • 53
  • 2
  • 10
  • What do you mean 'get the "Var", "Cum" and "VarYOY" rows into the matrix? Do you mean make them groupings horizontally or vertically or something else? They are showing so I do not know what you mean without more information of 'into the matrix'. – djangojazz Jul 25 '13 at 20:04
  • It seems like you have a lot of questions here - I would recommend breaking the issues down and asking one at a time. Also, provide sample data that can be copied/pasted instead of screenshots. One piece of advice looking at your dataset - it would be easier if you had one row per *custid/yearmo* with both the actual and forecast values. If you can pivot up your rows when generating the dataset it would prevent a lot of unnecessary aggregation in the report. – Ian Preston Jul 26 '13 at 14:24
  • Thanks, I will break it down and ask separately. – maverick07281975 Aug 06 '13 at 15:32

0 Answers0