+ Reply to Thread
Results 1 to 4 of 4

Showing Sales Trend In Pivot Table

  1. #1
    Forum Contributor
    Join Date
    02-26-2010
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    164

    Showing Sales Trend In Pivot Table

    I have a table of data. Column H represents 2017 sales data. Column I represents 2016 sales data. Column K is the difference %.

    For example, if Row 2 shows 41.34 for 2017 & 25.26 for 2016 that is a diff % of 63.66% (41.34-25.26)/25.26=63.66

    I need to be able to incorporate that in the values pivot table so. I tried googling instructions but's not working.

    I have two screen shots to show where I'm at.


    Thanks
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Showing Sales Trend In Pivot Table

    Here is what I have (if I am understanding your request)

    I left your calculation as is. So for the Pivot table

    Pivot table > Report Layout > Show in Tabular Form

    In my sample
    ROWS
    - Item
    - 2017
    - 2016

    Values
    - Difference

    Value Field Settings
    - Summarize value field by: SUM
    - Number Format: Percentage | Decimal Places: 2

    See attachment
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-26-2010
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    164

    Re: Showing Sales Trend In Pivot Table

    ^^^ Thanks for the help.

    I wish I could upload the file but it's larger than 1 MB. I see your example but I can't get it to work. How do I get to "pivot table > report layout > show in tabular form

    Thanks

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Showing Sales Trend In Pivot Table

    You're welcome and thanks for the rep.

    "I wish I could upload the file but it's larger than 1 MB."
    Will it be over the size limit if you compress (zip) it?


    "I see your example but I can't get it to work. How do I get to "pivot table > report layout > show in tabular form
    1. Click on the any of the pivot table headers. This will make the PIVOTTABLE TOOLS menu appear with two menu tabs.
    2. Click on the DESIGN tab
    3. Within the DESIGN tab, click on the button title REPORT LAYOUT, then click on SHOW IN TABULAR FORM

    See image below
    Showing Sales Trend In Pivot Table.jpg

    From here, you will need to configure the look for your needs.

    my suggestions would be to
    • Hide/filter blanks by clicking on the filter of the first header field of the pivot table.
    • Remove SUBTOTAL from every header by right-clicking on the header then uncheck Subtotal [Field name]

    See image below
    Attached Images Attached Images
    Last edited by Syrkrasi; 10-13-2017 at 10:01 AM.

+ 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. Replies: 1
    Last Post: 07-29-2016, 04:30 PM
  2. Average sales per week per sales representative in pivot table
    By R12345 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-15-2016, 07:16 AM
  3. Replies: 4
    Last Post: 06-19-2014, 12:59 PM
  4. Replies: 7
    Last Post: 07-22-2013, 11:29 AM
  5. Replies: 4
    Last Post: 03-27-2013, 05:56 PM
  6. add Trend Line to Pivot Table Chart
    By Matt D Francis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-27-2006, 11:30 AM
  7. Replies: 0
    Last Post: 04-18-2006, 02:10 AM

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