3 Replies Latest reply on Apr 29, 2013 7:58 AM by Shawn Wallwork

    Drill down in charts based on filters

    PR R

      Hi,

       

      We have a report with a chart showing Sales by Date. Have the following in the report.

       

      1. Custom built hierarchy in the report on Date (Year, Month, Week, Day)

      2. Filters on Year, Month, Week and Day and quick filters are enabled and are added to the context to enable cascading filters.

       

      what im trying to achieve:

       

      When i choose a Year, and leave the Month and Week filters defaultes to "All", i need to show the chart across the months of the year.

      When i choose a Year, and a Month and leave the Week filters defaultes to "All", i need to show the chart across the weeks of the month for the chosen year, month.

      When i choose a Year, a Month and a Week, i need to show the chart across the days of the week for the chosen year, month and week.

       

      Thanks in advance for any help on this.