Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table
I can't get a sum on a Currency formatted field in the table. I can get an
Item count. Suggestions are most welcome. wal50 |
#2
|
|||
|
|||
wal50,
Just to make sure--have you Double-clicked on the Data Field of the PivotTable and tried to change the Summarize By to Sum? It sounds like your data is not actually formatted as Currency but as Text. If so, you'll have to change this formatting in the Data Source or List that you used to create the PivotTable from. tj "wal50" wrote: I can't get a sum on a Currency formatted field in the table. I can get an Item count. Suggestions are most welcome. wal50 |
#3
|
|||
|
|||
Thanks, I got it. You gave me the clue.
Double clicking on the field name got nothing. I had to set up the table with a Count; select one of the cells and go to the field settings drop down to change it to a sum; then drag it to the table. Then I got both. They sure make it obscure. Thanks again. Wal50 "tjtjjtjt" wrote: wal50, Just to make sure--have you Double-clicked on the Data Field of the PivotTable and tried to change the Summarize By to Sum? It sounds like your data is not actually formatted as Currency but as Text. If so, you'll have to change this formatting in the Data Source or List that you used to create the PivotTable from. tj "wal50" wrote: I can't get a sum on a Currency formatted field in the table. I can get an Item count. Suggestions are most welcome. wal50 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |