Filtering individual row and not total

tableaucommunity@tableau.com — Tue, 02 Dec 2014 13:21:26 GMT

Hi there.

We have filtered on the Net Sales in one table and this works correctly.

In the next table we have combined some rows so they are totaling. The filter for 'Net Sales' is now filtering on the total here instead of the individual rows.

I know that by adding in the Unique ID for each row that it will show this information correctly, but we do not want to show each line. We want to show the totals only.

Example:

DATA:

A = 10

B = 20

C = 30

A = 25

F = 15

C = 5

Filter: >15

First table shows the below (which is correct as it is showing the individual rows)

B = 20

C = 30

A = 25

Second table shows the below

A = 35

B = 20

C = 35

ISSUE here is that it should only show 30 for C and 25 for A because the other values are not larger (>) than 15. But it seems to be totaling these and filtering on that instead.

If anyone has any idea on how to fix this, it would be greatly appreciated.

Thanks

Orla

Content in Tableau Community Forums

Filtering individual row and not total