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.