5 Replies Latest reply on Dec 4, 2018 3:34 AM by Zhouyi Zhang

    How to calculate percentage of total using  calculation

    sailu Tableau

      HI community,

       

      I was trying to show avg percentage but it was showing wrong . i unable to understand why it is happening.

       

       

      For Subcategory Single

       

      Calculated Average grand total of single (sub category) manually and the value is 88.9% but here it is showing 91.09%

       

      Not able to figure out issue.

       

      I have attached sample workbook also.

      https://drive.google.com/open?id=1Tvip7G-KJRNfIDckFJ6eGl2-mMokp3WW

       

       

      Thanks