Analyze Top Product Sales in Excel Pivot Table % Running Total

In an Excel pivot table, you can use the % Running Total calculation, to show the current running total amount, divided by the grand total.

For example, see what percentage of total sales come from the top 3 products.

Watch this video to see the steps.

Visit this page for more Pivot Table Running Total examples, and to get the sample file for this video -- In the download section, get the file, "Food Sales % Running Total")

https://www.contextures.com/xlPivot14...
Or use this short link: https://myctx.link/running

Video Timeline

00:00 Introduction
00:15 Sales Data
00:32 Make a Pivot Table
01:11 Add Fields
01:25 Sort by Price
01:53 Show Rank
02:48 % Running Total
03:42 Format Numbers
05:07 Add a Slicer

Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips #ExcelQuickTips

• #education
• #analyze_top_product_sales_in_excel_pivot_table_running_total
• #excel_pivot_table
• #running_total
• #excel_running_total
• #excel_pivot_table_running_total
• #excel
• #excel_tips
• #excel_video_tutorial
• #excel_tutorial
• #debra_dalgleish
• #contextures
• #contextures_inc