2 Replies Latest reply on Jul 17, 2012 2:52 PM by Andrew Watson

    How can I filter without changing percentage calculations?

    Timothy Stark

      How can I filter a text table without changing the percentage calculations?

       

      For example, I have 10 items in a table and I am calculating the quantity of each as a percentage of the total.

       

      However, for display purposes I only want to show the first 5.    But I want the percentages to still be calculated on all 10 items.  

       

      I've attached a before and an after example of how Tableau is changing the calculations.  Help!

       

      Tableau - filter sample 1.jpgTableau - filter sample 2.jpg