Hi all,
I have a problem in drill down in pie chart.I have 2 fact table sales and price.Sales has data of 2019,2020,2021,but price table has value for only 2021.In drill dimension I have 2 fields one from price table and other from master table (Item master).Problem arises when I filter the year 2020 .It automatically drill down to next from price dimension to item master dimension.
It drill dimension should not change even if I select year or any other date filter.
I appreciate if anybody helps .Thanks in advance.
