Dynamic Excel Report

Download Report: Link
Report Purpose:
- Show segment results by Channel for current period(month or quarter) vs. last period vs. same period last year as well as YTD current period vs. last year.
- Allow dynamic views for different time period chosed. For example,the current period in the below is Q2'14, when it changes to another quarter or another month,the report should change according without renaming, relinking orrebuilding the worksheet.
- Accurancy checking.
Method:
Formula: Vlookup(), IF(SUM()), SUMIF().