2 Replies Latest reply on Sep 30, 2016 9:35 PM by shiva chary

    Percentage of items in a dimension - Please help , iam not able to do the calculation

    shiva chary

      Hi Everyone, Iam new to Tableau claculations , Please helpme in doing the following calculation :

      I have total 5 elements in a Dimension : from thecolumn :  STATUS ( Attached excel)

       

      ANOB
      Started
      Offer declined
      Company No Interest
      Pending Offers

       

      i need the following claculation : 

      Accept % = (ANOB+Started)/(ANOB+Started+Offer declined)

       

      sample output in excel : I need this to be implemented in Tableau as below.

       

      Attached Excel book for the same , Please help me.

                                                                                                                                                                                                                                                                                                                                      

      OverallAPEuropeGCGISAJPLAMEANAWW
      Aug'16Jul'16Aug'16Jul'16Aug'16Jul'16Aug'16Jul'16Aug'16Jul'16Aug'16Jul'16Aug'16Jul'16Aug'16Jul'16Aug'16Jul'16
      Started20924929073725342717181720573327238545759438629384012
      ANOB16536682321966187572713112015811847811635911240
      Offer   Declined171295112924173230262630224842372458
      Company No   Interest6111711111511390045216887186
      Pending   Offers202881136295424072835491113
      Accept Rate96%96%91%90%97%95%95%91%97%88%95%93%98%98%92%92%95%92%
      Total Offered399308111211893604694179291176525074251379870955774796009