Thread: [Solved] Pivot table duplicate
View Single Post
 
Old 08-19-2015, 05:02 PM
Patchesohouli Patchesohouli is offline Windows 8 Office 2013
Novice
 
Join Date: Aug 2015
Posts: 1
Patchesohouli is on a distinguished road
Default Pivot table duplicate

In a table, I have all of my companies matching to the weeks they are working with us. Some companies are working with us one week (i.e. Sept. week of 7-11). Some are working with us several weeks. When I filter my pivot table by week, it only gives me the companies once. So if a company should be tied to two unique weeks, it will only show up once.

Here's a sample of my data table used to make the pivottable: [Data for Pivot Table](http://i.imgur.com/8zfMA4O.png)

And here's the result when I filter on a particular week: [Pivot Table Results](http://i.imgur.com/NnJ03Yb.png)

So basically, when I filter on Sept 21-25, it should show me BBC company as well. But it's not, as only filtering on Sept. 1-4 will return the BBC company.

Whenever a company stretches over a two week period, the pivot table only represents the first week. Should I be setting up my table differently?

Thanks for your help
Reply With Quote