Hi Quy, I experimented with the drill down dimension and while it can do as per what the video described, it did not achieve what the Excel Pivot chart with 3 levels of info on the X-axis can give to the analysts. By drill in, I can see info at the breadcrumb level but not at the breadload level. Also the drill down can only apply to a single selection. Let's say I have the production lot measure data for every month from 2017-2019. The Excel pivot chart will be able to display each production lot's measure from 2017-2019 so we can see how we are doing for each month and a very quick comparison month on month, year on year, lot on lot or at which month after countermeasure implementation that there was a step improvement of the measure. For the drill down dimension approach, I can only select 1 year, drill down to the months, select 1 month before I can see the production lot for the month. I cannot select 2 years and drill down further. Any alternative suggestion?
