10 Replies Latest reply on May 13, 2016 1:26 AM by Ashish Chaudhari

    How to divide 2 measures from different grouping?

    Yew Seng Lai

      Hi all,

       

      I have a source data like this

       

      KPI
      ProductTotal
      A. Total All ProductProduct A1000
      A. Total All ProductProduct B900
      B. Total Profitable ProductProduct A500
      B. Total Profitable ProductProduct B400

       

      Display in tableau sheet

       

      KPI
      ProductTotal
      A. Total All ProductProduct A1000
      Product B900
      B. Total Profitable ProductProduct A500
      Product B400
      Penetration B to AProduct A=(500/1000)=50%
      Product B=(400/900)=44.44%

       

      How can I get the 2 row as in RED? Do I need to create a calculated field?

       

      Please help..Thanks.