Drill down happening if there is no data in previous Year

[Rajkumar]

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.

[Prashant_N]

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

[Rajkumar]

Dear prashant, I tired nullify the All the Fields though not working .

[Ksrinivasan]

hi,

Introduce master calendar,

it will work,

ksrinivasan.