| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table HELP
i have a spreadsheet with columns ( Vender, Month, Amount ) i'm trying to set
up my table as follows: Column Fields are MONTH, Row Fields are Vender, and Data Items are AMOUNT. But when i put the AMOUNT in it changes to something like 1,2,3,4,5. How do i keep my AMOUNT as currency |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table HELP
Hi Michelle
Is it showing Count of Amount rather than Sum of Amount? Double click on the Amount Field heading, and Select Sum rather than Count. Whilst there, click Number, and select the Currency format you want. -- Regards Roger Govier "Michele" wrote in message ... i have a spreadsheet with columns ( Vender, Month, Amount ) i'm trying to set up my table as follows: Column Fields are MONTH, Row Fields are Vender, and Data Items are AMOUNT. But when i put the AMOUNT in it changes to something like 1,2,3,4,5. How do i keep my AMOUNT as currency |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table HELP
Thank you very much. It worked.
"Roger Govier" wrote: Hi Michelle Is it showing Count of Amount rather than Sum of Amount? Double click on the Amount Field heading, and Select Sum rather than Count. Whilst there, click Number, and select the Currency format you want. -- Regards Roger Govier "Michele" wrote in message ... i have a spreadsheet with columns ( Vender, Month, Amount ) i'm trying to set up my table as follows: Column Fields are MONTH, Row Fields are Vender, and Data Items are AMOUNT. But when i put the AMOUNT in it changes to something like 1,2,3,4,5. How do i keep my AMOUNT as currency |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Linear Mode
