2 Replies Latest reply on Feb 8, 2019 6:14 AM by Dietmar Freitag

    Percentage calculation with a filter but using the SUM of all entries

    Dietmar Freitag

      Hi,

       

      I have a problem, where I don't find a smart solution.

      The situation is very easy.

       

      Table:

      Region     Number

      a               4

      b               6

      c               10

       

      I want to show a bar chart, that shows the percentage of the overall sum.

      Easy so far.

      But now I want to use a filter to select only one Region. But the percentage should be calculated on the overall sum.

      Indepentdent form the filter, the percentage should be the same.

       

      Any ideas?

      I created a solution by using a similar second data source. The filter is only working for one Source an I can you the SUM of the other source to calculate the percentage.

      But I expect a smarter solution by Tableau.

       

      Thanks,

      Dietmar