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

# Beginner's Question on Row Calculations

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

• ###### 1. Re: Beginner's Question on Row Calculations

Would it be possible to do a filter that excludes items that have a % of Device = 100%? Anything that has only one part will meet that criteria.

• ###### 2. Re: Beginner's Question on Row Calculations

1) You can filter on the distinct count of the Parts dimension and set it to only keep devices where have COUNTD(Parts) > 1. Or you can built a flag.

COUNTD(Parts) > 1.  Drag that to the filters shelf. Keep 'True'.

2) you can use a table calculation drag Value to the rows shelf, right click, and then click on add table calc. You want % of total. Compute using Pane Down.

If you want to send a mock workbook, I'll step you through it.

• ###### 3. Re: Beginner's Question on Row Calculations

Possible solution.  The key for getting ones with both Part A and B only is in the filter.  See below.  The overall pct was done with a quick table calc.

1 of 1 people found this helpful