presently below chart shows at weekly basis.....requirement : display ddmmyyy week 1, ddmmyyy week 2, ddmmyyy week 3 etc in below chart.
if I click on (- )symbol in below chart. it will get month details ..than should display ddmmyyy
if I click on (- )symbol in below chart. it will get Quarter details--then should display FY yyyy Q1, FY yyyy Q2 etc
Please suggest for the case.
What about using a Parameter and sheet swapping instead of trying to control for all the different formatting options? This way you can create views for each level that make the best use of the space and are not restricted to the formatting/design of the other sheets.