Thanks! I've got the formula for the date detail parameter. I just don't know how to then utilize the parameter to actually change the data. Here is an example workbook and sample data.
I would like to be able to see the data from 1/1/10-8/31/11 at the different levels in the date detail parameter for whatever date range we choose in the date filter. So, by year for the data, by week, by quarter, etc.
You're a lifesaver, Joe. Thanks.
Thank you! This is very superb. I started using the date drill and ran into 2 issues:
1) How do I make the axis dynamic? For example, if one selects quarterly, then the axis displays Q1, Q2, Q3.. and switching to annually would change the axis to 2005, 2006 ..
2) In your example workbook you created a line chart, I have bars and I noticed, the date drill doesnt change the width of the bars.
Any help on the above is appreciated.