Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Like this
Like this
Great... Thanks Sunny... Saved My Day