This link has been bookmarked by 10 people . It was first bookmarked on 27 Apr 2010, by Steven De Beukeleer.
-
10 Feb 12
-
07 Feb 12
-
05 Dec 11
-
06 May 11
-
05 Jan 11
-
27 Apr 10
-
- 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.
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.
Now, your pivot is updated to show difference from previous column.
-
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.