11 Replies Latest reply on Oct 8, 2018 1:52 AM by Tushar More

    How to combine LODs and LOOKUP or something like this

    Cong Tran

      Hello All!

       

      I have a data table that contain Sale information for each Subproduct. It's here: Calculate - Product Name - Google Sheets

      Now I want to draw a cross table that show SUM(Sale) of "Type A Product" (not Subproduct) everyday.

      "Type A Product" is any Product has [SUM(Sale) Today] > [SUM(Sale) Yesterday]. I tried to combine FIXED and LOOKUP function but it's error

      Please help me to do that!

       

      Thanks so much!