ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Query (https://www.excelbanter.com/excel-discussion-misc-queries/128303-pivot-table-query.html)

Lee White

Pivot Table Query
 
Is there any way that in a pivot table I can include a columnso that data can
be manually entered in? General rules on pivot tables doesnt allow data to be
amended as you're amending the base data, however I need a blank column
within the pivot table so that i can add notes and figures to the data.

Thanks

Debra Dalgleish

Pivot Table Query
 
You can add notes adjacent to the pivot table, but you can't create a
blank column within the pivot table, or add freeform comments to it.

Lee White wrote:
Is there any way that in a pivot table I can include a columnso that data can
be manually entered in? General rules on pivot tables doesnt allow data to be
amended as you're amending the base data, however I need a blank column
within the pivot table so that i can add notes and figures to the data.

Thanks



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 04:42 AM.

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