2 Replies Latest reply: Sep 20, 2017 6:29 AM by Anurag Bharat RSS

    Percentage Of 2 Row in Pivot Table

    Anurag Bharat

      Hi All,

       

      Would request help on how to calculate a % row based on 2 row in a pivot table.

       

      I have unit numbers for each month for how many application received and from them how many got rejected for each product.

      Now I have created a pivot in QV like below.

      But Now I would like to show the % of Application approved for each product. Application received / Application declined for each product each month.

       

      Something like Below.

      Can I do that directly in the Pivot Table without adding any extra calculation in my table. Attached the QV for reference.

       

      Thank you.