Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-13-2023, 12:30 PM
schilling3003 schilling3003 is offline PowerPivot Subtotals Windows 10 PowerPivot Subtotals Office 2010 64bit
Novice
PowerPivot Subtotals
 
Join Date: Feb 2016
Posts: 3
schilling3003 is on a distinguished road
Default PowerPivot Subtotals

I have a pivot table, shown in the attached image. The pivot table is summarizing multiple types of data, and it is causing the totals to not calculate how I need it to. Each Store could have multiple surveys, so there may be multiple rows for each store, this is causing the "Forecasted Hours" to be added multiple times for stores that have multiple surveys. How can I have it only sum up each store once if they have multiple surveys. I can do an average to get each individual store to Subtotal correctly, but that does not fix the grand total.
Attached Images
File Type: png Screenshot 2023-06-13 152136.png (221.0 KB, 7 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot totals / subtotals ProudLiberal Excel 0 03-20-2020 06:04 AM
PowerPivot 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
PowerPivot 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
PowerPivot Subtotals Using subtotals in Pivot table formulas ninfanger Excel 3 10-23-2010 12:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:26 PM.


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