Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 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.
Hi,
Try to nullify the fields in expression on which you dont want the chart to change.
like this : Sum({<Year=,Month=,Quarter=>}Sales)
Regards,
Prashant
Dear prashant, I tired nullify the All the Fields though not working .
hi,
Introduce master calendar,
it will work,
ksrinivasan.