3 Replies Latest reply on Oct 26, 2016 1:53 PM by Chuck Stevens

    Beginner's Question on Row Calculations

    Shane Pickett

      Hi everyone. I'm new to Tableau and making good strides, but have hit a wall and would be grateful for some pointers.

       

      I am trying to create an analysis similar to what I've mocked up below:

      For each device, there can be Part A and Part B, or only Part A. I have two questions.

       

      First, how can I eliminate the rows that only contain Part A. In other words, I'd like to see only those devices that have BOTH Part A AND Part B. In the example above, Device 3 would NOT be shown.

       

      Secondly, how can I calculate the percentages of Part A and Part B for the device as a whole (as shown in my fourth column)?

       

      Appreciate any guidance.

       

      -- Robert