+ Reply to Thread
Results 1 to 2 of 2

Calculate a Percentage of 2 Numbers in a Pivot Table

Hybrid View

bluerog Calculate a Percentage of 2... 06-23-2021, 12:43 PM
Bo_Ry Re: Calculate a Percentage of... 06-23-2021, 03:12 PM
  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

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Calculate a Percentage of 2 Numbers in a Pivot Table

    Please add calculated Field

    Var%

    =IF('Retail Sales','Price Var'/'Retail Sales',0)


    For cumulative %
    Select show running total in Period
    Attached Files Attached Files

+ 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: 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