julietaContributor2 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 Contributor2 years agoUse filter.filter(Sum([Amount]),[Field1]='Criteria1' && [Field2]='Criteria2')
julietaContributor to db_pdx2 years agothis worked haha Iif([Account] Like '%[Field2]%' And [UD3] like '%[Field2]%', [Amount], 0) Thanks!
julietaContributor to db_pdx2 years agothis worked haha Iif([Account] Like '%[Field2]%' And [UD3] like '%[Field2]%', [Amount], 0) Thanks!
Related ContentBi Viewer SortingDrill down Chart in BI Viewer.[QuickView] Cross Time and Scenario FiltersDim String to use wildcard for datesBypass import records based off date in records (Time Dim)
