2 Replies Latest reply on Jul 24, 2018 12:29 PM by Fabiola Agramonte Bravo

    How to multiply subcategory columns?

    Fabiola Agramonte Bravo

      Hello,

       

      I am new to Tableau and I am having trouble with a table.

       

       

       

      I have created this table that has the four main categories (OTiF, On Time delivery, Invoice Accuracy, OS&D) and four subcategories in each (Cons, DPS, ECSS, Pharm). I would like to create a fifth category in the right hand side, so that I would have the category title (example: Category A) and the same four subcategories as the others. The numbers in this column would be a multiplication of all of the columns with the same subcategory name, shown bellow.

       

                 Category A

      Cons   DPS   ECSS   Pharm

       

       

      The resulting numbers would be: under the "Cons" column the total of the multiplication of all previous "Cons" columns, under "DPS" the total of the multiplication of all previous "DPS" columns, etc.

      Is there a way I can create some kind of calculated field in which I can multiply Cons1*Cons2*Cons3*Cons4= Cons5

       

      I appreciate the help.

       

      Sincerely,

      Fabiola