Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friend, I have some filters in the sheet :
where it says Bethel is a dimension called FNCT, but I want to ignore this dimension in the set analysis, and I want to add new filter for that dimension:
(Sum({<[ACCNT_CODE]={"88*"}, [LEDGER]={"A"}, [RSCE]={"UF*"}, [RSTR]={"3*"}, [FUND]={"10*"}, [FNCT]-={"DT*"}, [FNCT]=, [YearPeriod]={"$(=(max(YearPeriod)))"}>}[AMOUNT]*-1))
Thank you very much in advance
(Sum({<[ACCNT_CODE]={"88*"}, [LEDGER]={"A"}, [RSCE]={"UF*"}, [RSTR]={"3*"}, [FUND]={"10*"}, [FNCT]={'*'}-{"DT*"}, [YearPeriod]={"$(=(max(YearPeriod)))"}>}[AMOUNT]*-1))
I just change the filter name from the script... thanlk you for your answer!...