![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot table | pillaisg | Excel | 2 | 05-30-2015 03:27 AM |
![]() |
ubns | Excel | 1 | 04-17-2015 12:28 AM |
Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
Pivot Table Duplicate Data | cnw | Excel | 0 | 08-31-2012 08:24 AM |
![]() |
Karen615 | Excel | 5 | 08-03-2011 10:46 AM |