10 Replies Latest reply on Jul 2, 2016 2:02 AM by Ashish Chaudhari

    How to calculate grand total percentage?

    Biju J

      I have a structure like this in tableau

       

      Total Projects(COUNTD(PROJECTID))
      Date
      approved projects(COUNTD(APPROVEDPROJECTID)
      rejected projects COUNTD(REJECTEDPROJECTID)
      Rejection Rate(COUNTD(REJECTEDPROJECTID)/COUNTD(APPROVEDPROJECTID))*100
      10011-6-121505033%
      30012-6-122007537%
      Grand Total40035012570%

       

       

      The issue I am facing is I don't need the SUM of rejection rate in  grand total. I know this is happening because I used a calculated field for Rejection Rate. I need the percentage of grand total instead of SUM ie, (125/350)*100=35%. How to do that calculation?

       

      EDIT 1:

      One thing to add I am also using analysis->Grand Total ->Total using -> SUM. when I click automatic this shows correct but ,

      I need SUM since Grand Totals otherwise it will show COUNTD() of total rows. Any workaround?

       

      Thanks

      Biju

       

      Message was edited by: Biju J