Calculation filed in Pivot table

Dear all

I want to know how I would make a calculated field
Which the field in the data based is "Status", it is either "Yes"or "No".
I have pivoted it into 2 columns with a grand total.

Now I would like to show the % over the grand total of the "Yes"

Appreciate any help

Eric

Bo_Ry

Thanks and may i know how you make the additional column from the Inqury Type ?

Eric

Dear Bo_Ry

Thanks and i do not understand the "=N "
I saw your work on my table, add the additional columns.

But what if I have many choices, how would I handle it.

For example, if there are more choices such as
"Confirm", "Lost", Proposed, Pending and I need to know the ratio over the grand total?

Thanks for your advice.

Eric

Bo_Ry

Thanks a lot

Eric