4 Replies Latest reply: Sep 27, 2018 5:02 AM by Muhammad Hazim Muhammad Alif RSS

    How to sum measure without 1 row in the excel file (Data Source)?

    Muhammad Hazim Muhammad Alif

      Hi experts,

       

      let say this is the data from my excel file.

       

      ShopProductSales
      ADDD300
      BDDD400
      TOTAL700

       

      For some reason, the TOTAL rows i need to keep in the excel file.

      There are 21 shop in the excel

       

      so when i use formula:

      SUM(Sales)

       

      The result = 1400.

       

      so how to filter it?

       

      Thank you in advance!