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

    percentage displayed wrong in tableau

    Shri Siva



      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