4 Replies Latest reply on Jan 17, 2017 9:01 AM by . Berrett.Rice

    Creating a new line in a Dimension

    Antonio Neto

      Hey folks,

       

      I am new on using Tableau and there is something that my boss ordered me and I do not know how to do it. I know how to solve in the excel file itself, but I would like to learn how to do it through/using Tableau.

       

      The problem:

      I have an excel file where I have three columns: Project, Client and Value. The client dimension has 6 possible values (a,b,c,d,e, OT) whereas the letters "a" to "e" represent the mainly clients of the company, and the "OT" represents the total value of sellings.

       

      What I need is to make a simple table like the one that I send it below. That is, I need to make a simple table where I have Clients (a,b,c,d,e,Others, OT) and the values of each one (Others is calculated as "Sum of value of OT" - "Sum of the clients a to e").

       

       

      ClientValue
      a3650132
      b1828894
      c4684422
      d5543842
      e7582114
      OT90286049
      Others (OT - a - b - c - d -e)66996645

       

      Does anyone could help me please? I am also sending an excel file with some invented values in case it helps. Thank you in advance.

       

      -- Antonio