Thread: [Solved] Pivot table duplicate
View Single Post
 
Old 08-20-2015, 08:55 AM
Chancy Chancy is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jan 2015
Posts: 32
Chancy is on a distinguished road
Default

Did you change the name of the filter in the pivot table, from "Week of Column A" to "Sept Week of 21-25"? I think I see that you dragged in "Week of Column A". To get BBC to show up, you need to drag in "Week of Column C".

Whether I understood that part correctly or not, what you really need is to move BBC's data into Col. C. This image shows what I mean. I added data values to populate the pivot table just to illustrate.
Attached Images
File Type: jpg Snap1.jpg (34.1 KB, 14 views)
Reply With Quote