Thread: [Solved] Pivot Problem
View Single Post
 
Old 05-07-2016, 05:37 AM
jeffreybrown jeffreybrown is offline Windows Vista 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