How can I get the dates in the pivot table filter field to sort by "last week" "last month" "this year" "last quarter" etc? They show when I have a date format in the Axis Fields (categories) but when I want to use the date to just filter what time period is shown without actually showing dates on the chart I have to choose individual dates, one at a time. Please see the website below for some quick screenshots to see what I mean.
Thank you!
https://sites.google.com/site/pivotq/
Thank you!
https://sites.google.com/site/pivotq/