4 Replies Latest reply: Mar 16, 2018 5:14 AM by Andrea Gigliotti RSS

    ignore selection in firstsortedvalue()

    kong ch

      hi all,

       

       

      If I click the selection 'Store A', the Text Value in StoreB and StoreC is changed to null.

      I would like to ignore the selection (Store) in my expression ,

       

      the existing formula

      =firstsortedvalue(TextValue,-(aggr(sum(Amount),Store,TextValue)))

       

       

       

       

       

      StoreText Value
      Ahjk
      Boiu
      Cqwe

       

      thank you