ExcelBanter - How do you keep source values on a Pivot Table w/o formulas?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do you keep source values on a Pivot Table w/o formulas? (https://www.excelbanter.com/excel-programming/345872-how-do-you-keep-source-values-pivot-table-w-o-formulas.html)

dan the man stan

How do you keep source values on a Pivot Table w/o formulas?

I want to use a set of values as the data field in a Pivot table. Excel wants
to use a formula like COUNT in the data field. How do I prevent this? How do
I get Excel to use my values in the data field?

All times are GMT +1. The time now is 11:44 AM.