7 Replies Latest reply: Oct 26, 2015 11:56 AM by Jonathan Poole RSS

    Conditional Sum ( equal for 1 column, and ignore another column )

    Teck Rul Saw

      Sum({<Shipment_Qty_Type={"In Pool"}>}total_qty)  --This would filter the qty by qty type="In Pool"

       

       

      Sample Excel file:

      Item
      Shipment Qty Type
      Date
      Quantity
      AtypeAJune 201510
      BIn PoolNULL5000
      AIn PoolNULL200

       

      Right now, when my filter is by Month say June2015. Whatever I select in that Month filter, the In Pool quantity will not show.  How do I make that column ignore that Month filter?

       

      Sum({<Shipment_Qty_Type={"In Pool"}, 1Month={June 2015}>}total_qty)  --this will not work.