Skip to main content
J
julieta
Contributor
January 9, 2023

Bi Viewer - Cross dim in Lif

  • January 9, 2023
  • 2 replies
  • 0 views

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?

 

julieta_0-1673279280684.png

 

Thanks a lot!

2 replies

D
db_pdx
Contributor
January 9, 2023

Use filter.

filter(Sum([Amount]),[Field1]='Criteria1' && [Field2]='Criteria2')

J
julietaAuthor
Contributor
January 12, 2023

this worked haha Iif([Account] Like '%[Field2]%'  And [UD3] like '%[Field2]%', [Amount], 0)

 

Thanks!

J
julietaAuthor
Contributor
January 9, 2023

I will try, thanks!

 

Terms & ConditionsAccessibility statement