Percentage Of 2 Row in Pivot Table

[Anonymous]

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.

[sunny_talwar · Accepted solution]

Like this

[Anonymous]

Great... Thanks Sunny... Saved My Day