6 Replies Latest reply on Sep 15, 2018 6:12 AM by Zhouyi Zhang

    percentage displayed wrong in tableau

    Shri Siva

      Hi,

       

      I have the below table where I have to display percentage

       

      Percentage formula - Customer lot/Total *100

       

      Grand total is displayed as 3052  but actual sum ( 2,814 + 148 +59 +55 +29+21+17+8+6+5+2+1+1 ) is 3166

      so the percentage is coming wrong.

       

      Iam doing the following LOD function to fix the total across all rows

       

      SUM({Exclude [Error No]: COUNTD([CUSTOMER_LOT])}) that is also displaying 3052 .so iam not able to get the correct percentage.

       

      Please let me know what i wrong and why the grand total is coming wrong.I have attached the worksheet