Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I have a list of 56K rows with columns like date, action, and url. It's
raw web analytics data. The urls are from various domains but there are
lots of different urls for each domain. I'd like to be able to use that
data in a pivot table to look at the following ranges of data:
rows from a range of dates (say 6/15 - 6/22)
rows where the url contains a particular domain
rows where both of those are true
Surely I'm not the first person to want to do this? Searching for "pivot
table filter" and variations got me nowhere...
The only way I have been able to solve this problem has been advanced
filter -> copy using complex filter criteria
