This content has been marked as final. Show 2 replies
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.
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.