Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-07-2016, 05:37 AM
jeffreybrown jeffreybrown is offline Pivot Problem Windows Vista Pivot Problem Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Not sure I can explain why it was showing up as 100%, but adjusting your Pivot Table range to include the % column on the Raw data tab, it all works out I think as you need.

Check out the attachment...
Attached Files
File Type: xlsx TransferDestination - April 2016.xlsx (71.9 KB, 12 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Problem Create PIVOT chart using few rows in pivot table Santhosh_84 Excel 1 08-31-2015 06:22 AM
Pivot table pillaisg Excel 2 05-30-2015 03:27 AM
Pivot Problem Excel 2010 Pivot table problem Kris TenEyck Excel 4 02-01-2014 01:26 AM
Pivot Problem Pivot table grouping problem 2 tables need different grouping differentdrummer Excel 3 12-10-2013 01:19 AM
Pivot Problem Pivot table problem swindon Excel 5 05-25-2010 02:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:17 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