Pivot table converts data to a 1,2,3 how do I get data to correct
I created a pivot table from a range of customers (deposits). Tha data range
counted the number of entries per customer and not the dollar amount. How do I format the data range to reflect the dollar amount not the number of entries? |
Right-click on the 'Count of Deposits' button in the pivot table
Choose Field Settings From the 'Summarize by' list, select Sum Click OK mjohnston1327 wrote: I created a pivot table from a range of customers (deposits). Tha data range counted the number of entries per customer and not the dollar amount. How do I format the data range to reflect the dollar amount not the number of entries? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 02:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com