Results 1 to 4 of 4

PIVOT - Show values as Difference From

Threaded View

  1. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,823

    Re: PIVOT - Show values as Difference From

    If I understand correctly then:
    1. Drag SL% down to the Values area again and change the "Show values as" to Difference from > week > previous (Number format > percentage)
    2. [Optional] Change the column header of the new columns to read: Diff from previous week
    As to the 2nd problem, when I started to produce another pivot table the original one suddenly showed the values in the "Sum of SL %" columns (I don't know why that happened).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can I show the difference between 2 counted columns in a pivot?
    By kufta4 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-12-2021, 10:27 AM
  2. Replies: 3
    Last Post: 07-11-2018, 05:33 AM
  3. Show values as difference from.Bug
    By wisetex in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-23-2014, 07:42 PM
  4. Pivot Table to Show difference between Min and Max Value
    By bigroo1958 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2013, 09:06 PM
  5. Replies: 7
    Last Post: 08-04-2011, 09:32 AM
  6. Show difference between values as a percentage
    By gkitf16 in forum Excel General
    Replies: 2
    Last Post: 08-31-2010, 12:12 AM
  7. add a column to a pivot table that would show the difference between 2 other Columns
    By jbesr1230@hotmail.com in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-30-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1