Skip to main content

Steven De Beukeleer

Steven De Beukeleer's Public Library

    • 4. Show difference from last month (or year) without bending backwards

       

      We all know that you can show monthly summaries using Pivots. But what if your boss wants you to also include “difference from previous month”  as well? Now, dont rush back to source data and add new columns. Here is the right trick to make you a star.

       
         
      • Just use field settings to tell excel how you want the data to be summarized.
      •  
      • Right click on any pivot table value, select “value field settings”
      •  
      • Now go to “Show value as tab” and Change “Normal” to “Difference from”
      •  
      • Select “Previous” from Base-item area. Leave Base field as-is.
      •  
       

      Now, your pivot is updated to show difference from previous column.

       

      Difference From Last Month Pivot Report

1 - 20 of 611 Next › Last »
20 items/page

Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »

Join Diigo