Filter not working?

[cbaqir]

I don't understand why my filters aren't working. For example, if I make a selection in the Sub Unit field, I would expect only to see the rows for the selected Sub Unit, but I see more than that.

What am I missing?

TIA

[sunny_talwar · Accepted solution]

You are ignoring selection in AU_SUB_UNIT which is why the first 4-5 expressions are not becoming 0 and chart is still showing the other AU_SUB_UNIT

Sum({<FISCAL_MONTH_YEAR={"$(=Max({<YTD_GL_AMT = {'*'}>}FISCAL_MONTH_YEAR))"}, AU_NUM_NAME, AU_SUB_UNIT, PROG_NON_PROG>}YTD_GL_AMT)

[sunny_talwar]

Check the attached