Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Check the attached