Conditional Filter based on Selection

Hi All,

Based on excel data, i have 5 columns which i have pivoted to form a single column For e.g.(A+B+C+D+E).

Out of the 5 columns , the last i.e the 5th column  i.e (E) is the sum of the 4 columns.

I have a map and a bar chart on my dashboard and need to use this pivoted column as a filter.

The issue is when I use this filter on dashboard , the filter shows up 'All' option. Clicking on 'All' option sums up all the values which gives me a wrong result since 'E' is already a summation of (A+B+C+D) on the map.

Excluding 'All' from filter will work for map but then i will not be able to show all values on the chart i.e A+B+C+D+E at once.

Can any one assist me on this.

Thanks and Regards,

• 1. Re: Conditional Filter based on Selection

Unless I'm missing something, just don't include the 5th column in your pivot as Tableau will do the summing for you.

• 2. Re: Conditional Filter based on Selection

John,

By doing that and using it as a filter , my map would work exactly fine but then I have a chart as well where i need to show all the 5 values. How will i get that, since the filter will only show the four values and the 'All' option.

I am attaching a test application.

In the dashboard , i have a map and chart. Now, when i select any values from A to D, I get the proper aggregated value on the map as well as the chart, the moment I check 'E' , numbers go for a toss on the map, since 'E' is already an aggregation of A to D  though it comes up properly on the table.

The user wants to all the values from A to E on the chart , so as he is able to compare the performance of 'A' against 'E'

• 3. Re: Conditional Filter based on Selection

Will not using Grand totals suffice for your purpose in the table?  I cannot seem to attach workbook as I am getting content type not allowed message.

• 4. Re: Conditional Filter based on Selection

Hey John,

The problem is solved, I ignored the column E in the pivot as you said earlier  and used it as a second measure on the chart. The client is fine with the view as of now.