3 Replies Latest reply on Jun 29, 2015 11:19 PM by Sein Chyi Woo

    how to create a WeekNumofQtr+DayofWeek drilldown

    Jesse yung

      how to create a hierarchy with:

      1. wkofqtr: which ranges from 1 to 14

      drill down to

      2. day of that wk: could be mon to sun or exact date

       

      In the workbook attached, there're 2 issues:

      1.when drill down, weekday become the higher hierarchy. it's supposed to be under wkofqtr

      2. the lines are discontinuous when drilled down.

       

      Any advice?

       

      thanks.