This content has been marked as final. Show 2 replies
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.