Unless I'm missing something, just don't include the 5th column in your pivot as Tableau will do the summing for you.
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'
test_file.twbx 39.6 KB
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.
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.
Thanks for your time and advice.
By the way I had attached a workbook , don't know why is it throwing such an error.I can download and open the same workbook on my machine.