I have daily sales information
day/month/year Sales Amount
Want to create a report that has
Group One Year 2008 Sum Year 2009 Sum
Then drill down to
Year 2008 Year 2009
Jan
Feb
Mar
etc
Then drill down to weeks etc.
My trouble is gettting Crystal 10 to get years in column format, then drill down in column format to months. Cross tabs doesn't allow drill down and I can't get the month in column format with cross tabs either.
There must be a simple solution, even if there is not. I am spinning my wheels.
Thanks in advance