ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Possible to create formula columns within Pivot Tables? (https://www.excelbanter.com/excel-discussion-misc-queries/178179-possible-create-formula-columns-within-pivot-tables.html)

Pat Dools

Possible to create formula columns within Pivot Tables?
 
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.
--
Pat Dools

Herbert Seidenberg

Possible to create formula columns within Pivot Tables?
 
Instead of a calculated field,
add a column to your source data:
http://www.freefilehosting.net/download/3cklj


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com