Link to home
Start Free TrialLog in
Avatar of Inframap
InframapFlag for United States of America

asked on

Pivot Table Calculate Percentage Increase/Decrease

I have an Access piVot table that shows $ amounts for the the last year and the current Year

2011                                       2012                                          Grand Total
01        02 ...  Etc                    01         02  ....    ETC                 2011     2012
500$    700$                           650$     600$                            1200$    1250$

I need to show the percentage increase/decrease of Jan 2011 vs Jan 2012   feb 2011 vs Feb 2012

2011                                       2012                              % Increase/Decrease
01        02 ...  Etc                    01         02  ....    ETC      01       02
500$    700$                           650$     600$                  23%    -16.7%

I will also need to be able to then Sort by Grand total Percentages Increase/Decrease %

Thanks For the help!
ASKER CERTIFIED SOLUTION
Avatar of oleggold
oleggold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Inframap

ASKER

I do not want to use excel.