Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JASalinas
Creator
Creator

Ignore Dimension Filter with Set Analysis

Hi friend, I have some filters in the sheet :

Captura de Pantalla 2022-09-05 a la(s) 9.50.14 p.m..png

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

 

2 Replies
BrunPierre
Master
Master

(Sum({<[ACCNT_CODE]={"88*"}, [LEDGER]={"A"}, [RSCE]={"UF*"}, [RSTR]={"3*"}, [FUND]={"10*"}, [FNCT]={'*'}-{"DT*"}, [YearPeriod]={"$(=(max(YearPeriod)))"}>}[AMOUNT]*-1))

JASalinas
Creator
Creator
Author

I just change the filter name from the script... thanlk you for your answer!...