Possible to create formula columns within Pivot Tables?

P

Pat Dools

Hello,

Is it possible to insert formula columns into a Pivot Table? If you have
counts of insurance quotes and bound policies within the same Pivot Table,
could you have another formula column within the Pivot table to show the
percentage of quotes that have become policies?

We're currently adding another column to the right of the Pivot table, but
this is clumsy, and this added column easily falls out of alignment with the
Pivot table, depending on how many records you have from one data Refresh to
another.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula in pivot excel 2007 1
conditional formula 1
pivot table counting 1
Appending columns or calculation to pivot tables 1
Pivot Table 1
convert text to columns 2
Formula fields in Pivot Tables? 1
Pivot table--and adjacent columns 1

Top