+ Reply to Thread
Results 1 to 4 of 4

PIVOT - Show values as Difference From

  1. #1
    Registered User
    Join Date
    12-23-2012
    Location
    Banja Luka, B&H
    MS-Off Ver
    MS Office Excel 365
    Posts
    20

    PIVOT - Show values as Difference From

    Hi,

    I need to compare some values based on first value in Label side. I am using Pivot feature show values as difference from.

    The problem is that this feature works only for first Label group, for the other it doesn't because data is dynamic and not same. How can I avoid this?

    The 2nd problem is that in this feature Pivot do not shows values of first row in Label group. How can I set it to show up?

    Example in attachment.

    P.S. If not possible via raw pivot, I would like to add helping column in data sheet, then try Pivot.

    Best regards
    Attached Files Attached Files
    Last edited by LemitoSanchez; 11-09-2020 at 08:28 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: PIVOT - Show values as Difference From

    What is the " week" column supposed to mean ?
    The " week" with nr 30 spans more than a month. Are those real weeks, or something else?
    Last edited by Pepe Le Mokko; 11-09-2020 at 11:53 AM.

  3. #3
    Registered User
    Join Date
    12-23-2012
    Location
    Banja Luka, B&H
    MS-Off Ver
    MS Office Excel 365
    Posts
    20

    Re: PIVOT - Show values as Difference From

    It's not real week. It is something for measuring. It can be anything.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    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.

+ Reply to Thread

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. 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