2 Replies Latest reply on Jul 29, 2018 11:41 AM by Darius Novak

    Calculate sum as producer and as consumer(sumif)

    Darius Novak

      Hi,

      I am trying to do something similar to "sumif" in Tableau.

       

      My data looks like

       

       

      Producer IDConsumer IDValue
      AD2
      BC34
      DA3
      CB2

       

       

       

      The result I am ater, that I want to use in stacked bar:

      IDConsumed Value

      Produced

      Value

      A32
      B234
      D23
      C342

       

       

       

      Would anyone be able to help?