13 Replies Latest reply on Oct 14, 2016 9:12 AM by Lisa Li

    Need help in calculation ( multiple criteria)

    shiva chary

      Hi All,

      Request to all ,

       

      Attached sample Tableau file.

      I need the below calculation in tableau,  similar to snapshot from excel :

       

      The above percentage is achieved using below calculation :

       

      required tableau Calculation : [ (filters: Attrit type = Vol Attrit & Supported type = Supported ) count of Attrit Type  ]    /  [    (total count of Attrit type)    No filters  ]

       

      first cell value from each of 3 tables : 11/159 = 7% ( from below 2 tables / above table)

      i.e,

       

        divided by