Forum Discussion

julieta's avatar
julieta
Contributor
2 years ago

Bi 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!

BI Viewer
  • db_pdx's avatar
    db_pdx
    Valued Contributor
    2 years ago

    Use filter.

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

    • julieta's avatar
      julieta
      Contributor
      2 years ago

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

       

      Thanks!