I have set up an account schedules that interrogate chart of accounts filter by cost centre a global dimension. This produces the correct result in a bar charts. However when I click on bar chart ,it drills to chart of accounts but has not filtered the cost centre I had in accounts schedules.

example chart of accounts 1234  has $10,but my account schedule shows $3 because I have filtered by cost centre a. the bar graph shows $3 which is correct but when I click on chart it shows account 1234 and amount $10 ie loses the filter cost centre a. This is confusing for users of information ie manager of cost centre a

how do I set up correctly?