Expression already add filter , How to avoid manual filter ?

[paulyeo11]

Hi All

I have a GL Table , when i select 2012 and Dec , it will display all GL_CODE on Table 1. Mt expression as below :-

=money(fabs(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"$(=Date([YearMonth],'YY MMM'))"}, month = ,year=>}[Amount])), $(vCurrency)))

Now i when Press button on Step 2 , it will filter those GL Code i need , and display at the result at Table 2. My expression as below :-

=money(fabs(if([Exec P&L Level] = 's','',Sum({$<YearMonth = {"$(=Date([YearMonth],'YY MMM'))"},[GL_CODE] = {"50030","50060","50016","50010","50011","50022","50040","50020","50090"}, month = ,year=>}[Amount])), $(vCurrency)))

Now my question is , with out user click on Step 2 button , how to make Table 2 appear ? Now user need to press button step 2 , my aim is avoid user press button step 2. Since in my expression already filter those GL CODE. which is same as press button.

Paul

[swuehl · Accepted solution]

Maybe like attached?

[paulyeo11]

Hi Stefan

Thank you very much for your help. It work now.

Paul