|
|
#5
02-24-2015, 06:03 PM
|
|||
|
|||
I have attached the sheet. I used the table2 as the data range for both. I clicked on Pivot Table options for both and it has the as Pivottable1 and PivotTable2. Is it still using my table as a source? My table is called Table. As I add I want it to refresh and add everything new.
Also, in cell K2 I have the text video twice. I used a countif function to count that column but it is only counting video in that field once. Do you have any suggestion on what formula to use to calculate it twice in that field? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 | uhlersa | Excel | 0 | 10-15-2012 12:01 PM |
| Pivot table help | TishyMouse | Excel | 2 | 04-27-2012 10:19 AM |
 pivot table
|
aliasadi_07 | Excel | 1 | 03-11-2012 12:49 AM |
|
Help with a pivot table please!
|
natsha | Excel | 1 | 02-16-2012 12:41 PM |
Windows 7 64bit 
Office 2007
Threaded Mode