Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 03-20-2020, 06:04 AM
ProudLiberal's Avatar
ProudLiberal ProudLiberal is offline Pivot totals / subtotals Windows 10 Pivot totals / subtotals Office 2019
Pivot totals / subtotals
Join Date: Jun 2017
Location: suburban Chicago
Posts: 26
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

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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:36 PM.

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. is not affiliated with Microsoft