table1 is the source for both pivot tables. They seem to work for me.

As for counting video twice, no I don't really have any thoughts on that. Not sure why you want to, but I bet there are far better ways of doing this.