L
lrivers
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
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