I'd like to compare Unit Sales from 2009 against Unit Sales from 2008. My source data give me Sales Date and I can grab Unit Sales count in the Value Field of the Pivot Table. I've already got other items as Column and Row Labels so I can't simply list the Sales Dates there. Additionally I need to add calculated fields based on the 2009 vs. 2008 Unit Sales. Effectively I want the end result to looks like this:
Column Label
Row Label------Model 1-----------Delta-----------% Change-------Model 2-----------Delta-------------% Change
Make 1------2009 | 2008------('09 minus '08)------('09 / '08)------2009 | 2008------('09 minus '08)------('09 / '08)
Make 2------2009 | 2008------('09 minus '08)------('09 / '08)------2009 | 2008------('09 minus '08)------('09 / '08)
Make 3------2009 | 2008------('09 minus '08)------('09 / '08)------2009 | 2008------('09 minus '08)------('09 / '08)
Make 4------2009 | 2008------('09 minus '08)------('09 / '08)------2009 | 2008------('09 minus '08)------('09 / '08)
Model 2, Model 3, etc. repeat the Delta and % Change calculated fields of Model 1.
How do I go about doing this? Do I filter the 'sub' columns somehow? How do I add the calculated fields?
Thanks!
Bookmarks