Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2020, 06:04 AM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline Pivot totals / subtotals Windows 10 Pivot totals / subtotals Office 2019
Novice
Pivot totals / subtotals
 
Join Date: Jun 2017
Location: suburban Chicago
Posts: 25
ProudLiberal is on a distinguished road
Default Pivot totals / subtotals

I've got a pivot table that correctly calculates a cumulative % of the total number of items being counted. BUT, when I filter the pivot, the percent of total column calculates using unfiltered total. How can I get the % of total to use the filtered total in the calculation?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summary page of totals? srussell Mail Merge 1 08-13-2019 11:16 AM
Pivot totals / subtotals Trying to find a way to calculate subtotals for different sections of an invoice w/ data validation excerbated123 Excel Programming 2 02-03-2015 09:28 PM
Pivot totals / subtotals Multi Level Subtotals w 2 Grand Totals That Don't Match DavidW Excel 3 10-09-2014 07:08 AM
Can I sort a Pivot table by subtotals? oshkosh Excel 1 12-07-2010 06:20 PM
Pivot totals / subtotals Using subtotals in Pivot table formulas ninfanger Excel 3 10-23-2010 12:29 AM


All times are GMT -7. The time now is 10:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft