3 Replies Latest reply on Feb 11, 2016 10:43 AM by Shawn Wallwork

    Calculation on different values

    tableau gstl

      Hi All,

      Can I pick profit from specific Category -> Furniture and Technology separately and implement addition or minus

       

      Similarly Sales from Sub-Category and profit from any Category and add them

       

      Tried creating separate calculated fields but it did not work

      Envelope Sales

      if [Sub-Category] = "Envelopes" then [Sales]

      END

       

      Furniture profit

      IF [Category] = "Furniture"

      then [Profit]

      END

       

      Technology profit

      IF [Category] = "Technology"

      then [Profit]

      END

       

      Sum

      SUM([Furniture profit])+SUM([Envelopes Sales])

       

       

      Minus

      SUM([Technology profit]) - SUM([Furniture profit])

       

      I would like to pick values randomly and calculate different metrics

      can someone please help?

      Thanks in Advance