julietaContributor3 years agoBi Viewer - Cross dim in Lif Hey guys! Happy new year. Do you know if there is a way to use more than one dim in the lif section for a calculated field in BI Viewer? Thanks a lot! Show More
db_pdxValued Contributor3 years agoUse filter.filter(Sum([Amount]),[Field1]='Criteria1' && [Field2]='Criteria2')
julietaContributor to db_pdx3 years agothis worked haha Iif([Account] Like '%[Field2]%' And [UD3] like '%[Field2]%', [Amount], 0) Thanks!
Related Content[QuickView] Cross Time and Scenario FiltersDim String to use wildcard for datesHow do I get a dim name (dimpk) from a dim ID?Bypass import records based off date in records (Time Dim)Bi Viewer Sorting