Results 1 to 2 of 2

Calculate a Percentage of 2 Numbers in a Pivot Table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-18-2009
    Location
    Cincinnati
    MS-Off Ver
    Excel 2007
    Posts
    101

    Calculate a Percentage of 2 Numbers in a Pivot Table

    I have a worksheet with retail sales over multiple periods. In the data table, I've calculated Price Variance to previous period.

    1) I am wondering if it's possible, in the pivot table, to calculate a Percentage: Price Variance $ / Retail Sales $ for each period.

    2) Extra points if it can do that % Price Variance calculation in the pivot table... and then give a cumulative % change from all period before it?


    See the attached worksheet for an example.

    And thanks much in advance.

    Roger!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 04-21-2021, 06:03 AM
  2. How do I calculate a percentage between fields in a pivot table?
    By plasteredric in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-18-2020, 11:06 AM
  3. Pivot table and percentage numbers
    By donkyklonk in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-09-2017, 11:01 AM
  4. [SOLVED] How to calculate percentage within pivot table
    By GIS2013 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-12-2016, 08:29 PM
  5. [SOLVED] How to calculate percentage in a pivot table (from a tally)?
    By o0o0OoO0o0O0oo00o0O0 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-22-2013, 11:54 AM
  6. How to calculate percentage change between values in a pivot table
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-03-2013, 01:48 PM
  7. Replies: 2
    Last Post: 05-18-2009, 09:14 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