I am trying to add a % change calculation to a pivot table. Example Columns are Jan, Feb, Mar and rows are Apples, Pears, and grapes. I want it to auto calculate for each row the % change from Jan to March…..=(JanApples – MarApples)/MarApples
Any suggestions on doing it with in the pivot...
If you are using Excel 2010 View->New Window will allow you to open and update the same document twice so you can see multiple tabs at the same time. You will need to move/resize the windows mannually or select Arrange All and then it will resize for you. If using 2 different worksheets...