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.
|