My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Excel PivotTable Add Percentage of Total Column [Video]

You are here: Home / Excel PivotTables / Excel PivotTable Add Percentage of Total Column [Video]
Excel PivotTable Add Percentage of Total Column [Video]
by

Excel PivotTables make light work of analysing data but there are a few tricks once you get past the basics.

In this first tutorial, in my 3 part series on PivotTable tips and tricks, I’m going to show you how to add a percentage of total sales to your PivotTable like this one in column C below:

PivotTable percentage of column

Watch the Video

For best viewing watch the video in 720p HD full screen.

Download the Workbook

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.

Written Instructions - How to Add a Percentage of Total Column

1. Add an additional set of Sales values to the Values field from your Field List.

You will have two 'Sum of Sales' fields like this:

PivotTable percentage of column

2. Right click on any of the cells in the 'Sum of Sales2' column in your PivotTable and select 'Value field settings'.

3. Click on the 'Show Values As' tab and select '% of Column Total' from the 'Show values as' list and click OK.

PivotTable percentage of column

More PivotTable Tutorials

Click this link for more on Excel PivotTables

Do you want more like this?

Let me know by sharing this tutorial on Facebook, Twitter, LinkedIn or +1 on Google by clicking the icons below, or leave a comment and tell me what other tutorials you'd like.

Excel PivotTable Add Percentage of Total Column [Video]

Microsoft MVP logo

AUTHOR Mynda Treacy Co-Founder / Owner at My Online Training Hub

CIMA qualified Accountant with over 25 years experience in roles such as Global IT Financial Controller for investment banking firms Barclays Capital and NatWest Markets.

Mynda has been awarded Microsoft MVP status every year since 2014 for her expertise and contributions to educating people about Microsoft Excel.

Mynda teaches several courses here at MOTH including Excel Expert, Excel Dashboards, Power BI, Power Query and Power Pivot.

More Excel PivotTable Posts

show report filter pages for power pivot pivottables
PivotTables created from Power Pivot can't use the 'Show Report Filter Pages' option. But this piece of VBA allows you to do just that.
automating and emailing pivot table reports
Automate the creation and distribution of pivot table reports with some VBA. Send reports to multiple email recipients using Outlook.
Hide blanks in Excel PivotTables caused by empty cells in your source data. I’m talking about PivotTable cells containing the (blank) placeholder.
Conditional Formatting PivotTables
Conditional Formatting PivotTables values areas will automatically expand/contract as you add new data or make changes to the filters, rows or columns.
Display Missing Dates in Excel PivotTables
Filter Excel Pivot Tables by Values
Excel PivotTable Month Comparison [Video]
Excel PivotTable Month Comparison is easy with the Show Values As tool.
Excel Factor 6 Auto Refresh PivotTables
Excel Factor Entry 1 - Reverse PivotTable

More Excel PivotTables Posts

Advanced PivotTable Techniques
Discover 7 advanced Excel PivotTable techniques to streamline your data analysis and create dynamic, insightful reports with ease.
Sorting Excel Date Slicers
Use these tricks to custom sort Excel Slicer buttons enabling them appear in a specific order that suits your needs.
PivotTable Formatting
Create PivotTables that don’t look like PivotTables with these really easy PivotTable Formatting tips and tricks.
Images in Excel Pivot Tables
Include images in Excel PivotTables, combined with some slick formatting, and create dynamic and visually rich PivotTables like never before.
Auto Refresh PivotTables isn’t on by default, and the process differs depending on if your PivotTables is loaded to the data model or not.
Show Items with no Data in PivotTables allows you to maintain a constant structure to your PivotTable or Pivot Chart axis when filtering.
There's no build in way to force Excel Slicers to single select but we can use these clever warnings to persuade your users.
excel pivottable p&L
Creating an Excel PivotTable Profit and Loss Statement means you can use Slicers and Conditional Formatting and have the P&L automatically update.
Customize the Excel PivotTable Field List to suit your needs. Find how to turn the PivotTable Field List on and off and other handy tips.
Hide blanks in Excel PivotTables caused by empty cells in your source data. I’m talking about PivotTable cells containing the (blank) placeholder.


Category: Tag:

Reader Interactions

Comments

  1. Petar

    Hey beauty!
    I’m looking for a ways around those two problems:
    It seems I cannot combine the value of two (or more) Sparklines – any ideas?
    And I want to automatically have the result for 5 g (grams) out of 100 g
    Please, do not hesitate to email me!
    Kindest regards,

    Reply

  2. Sabir Hussain

    How to add % when we have three column including Project titles, Planned yearly targets and achieved progress. Here I want to add % column.

    Reply

    • Mynda Treacy

      Hi Sabir,

      Please send a sample file via our Help Desk, with your data and the percentages you’d like to see in your PivotTable manually calculated outside of it, so we know what your expectations are.

      Thanks,

      Mynda

      Reply

  3. 6tel

    Mynda, you are the greatest. I’ve been looking for an answer on this for almost an hour. Thank you very much.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Current ye@r *