I am a long time reader.... first time poster.
I've been asked to create weekly report for a number of metrics which compares the last week to the prior week as well as the current month to the month to date. The challenge I've been having is displaying multiple time periods; last week, 1 week prior to last week, current month and prior month to date. My month to date needs to evaluate the measure value of the current month to the prior month for the same day of the month. I've been able to work through some of the request but, ultimately displaying percent on the same line as the measurement has been problematic. I've tried using parameters for the measurements. I find that using a parameter only shows the default value. Using the date filter I can limit the time ranges. None of the solutions I've found help me create the following report format.
|10/13/2013 (Last Week)||1 Week Prior||% Change from Prior Week||Month To Date||% Change from Prior Month|
|Number of Sessions||25||28||-10.71%||78||-2.50%|
|Number of Flights||5||6||-16.67%||18||-14.29%|
|Usage Per Session||400||429||-6.67%||423||-10.93%|
Can anyone help me with this?
Would you be able to upload a packaged workbook with sample data?