YTD and PYTD VALUES

I have one table that had all my sales for two years.  I am trying to get the YTD AND PRIOR YTD totals based on a manufacture and based on the distributor.

manufacturer
distributor  date. Month. Prior Year Month 

this goes on for YTD AND PYTD.  I'm also needing the $ diff and 0/0 percentage diff.

had no luck with help desk but they are trying.  If you could help I would be forever grateful (and probably still employed).



------------------------------
Lori Pelzel
248.869.2000
------------------------------