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