Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table setup
I need to setup a pivot table where I may see all expenses by vendor or by
year or by quarter or by month/year. This should help me to forecast for next quarter and year. I should also be able to see totals by expense code (it groups different types of vendors). I will also need to setup sort order. My data table will have the following columns: Vendor-Name, Invoice-Date, Invoice-Number, Description, Amount, Expense-Code, Process-Date, Comments. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table setup
Is there a question in there somewhere? What you have sounds fine by me. The
only caution I would have is if you have more than 8,000 unique comments or Invoice numbers then the pivot table will break down. -- HTH... Jim Thomlinson "Vic" wrote: I need to setup a pivot table where I may see all expenses by vendor or by year or by quarter or by month/year. This should help me to forecast for next quarter and year. I should also be able to see totals by expense code (it groups different types of vendors). I will also need to setup sort order. My data table will have the following columns: Vendor-Name, Invoice-Date, Invoice-Number, Description, Amount, Expense-Code, Process-Date, Comments. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table setup
My attempts to setup this pivot table were not successful. Dollars don't get
totalled. It counts how many invoices I have instead of counting the money. There are some wierd subtotal lines that I don't need at all. I just need $$ totals by vendor or category or month or year or quarter. How do I do all of that? I don't know how to attach the file that I used. Can I send you my files? It is 57kb and has 55 invoice rows. "Jim Thomlinson" wrote: Is there a question in there somewhere? What you have sounds fine by me. The only caution I would have is if you have more than 8,000 unique comments or Invoice numbers then the pivot table will break down. -- HTH... Jim Thomlinson "Vic" wrote: I need to setup a pivot table where I may see all expenses by vendor or by year or by quarter or by month/year. This should help me to forecast for next quarter and year. I should also be able to see totals by expense code (it groups different types of vendors). I will also need to setup sort order. My data table will have the following columns: Vendor-Name, Invoice-Date, Invoice-Number, Description, Amount, Expense-Code, Process-Date, Comments. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connecting a Pivot Table to .Tab Data file ** Minimise the connexion setup hassle | Excel Discussion (Misc queries) | |||
When using show pages in a pivot table can I keep the page setup? | Excel Discussion (Misc queries) | |||
Pivot Table Setup | Excel Discussion (Misc queries) | |||
how do you setup a table | Excel Worksheet Functions | |||
why can't I setup a macro to run Pivot Table? | Excel Discussion (Misc queries) |