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
