Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
pivot table with dynamic base data | Charts and Charting in Excel | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |