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]



      Furniture profit

      IF [Category] = "Furniture"

      then [Profit]



      Technology profit

      IF [Category] = "Technology"

      then [Profit]




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




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


      I would like to pick values randomly and calculate different metrics

      can someone please help?

      Thanks in Advance