| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Pivot Table based on From and To Dates
I have a list of revenue amounts based on from a to dates. I need to
generate a pivot like table that will show an even spread based on those amounts. Anyone have any ideas ? For Example Type From To Amount Service 1-jan-03 31-dec-03 12,000 Service 1-jul-03 31-dec-03 12,000 Type Jan Feb Mar ... Jul Aug ... Dec Total Service 1000 1000 1000 3000 3000 3000 24000 Thanks Uri |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| How do I Create another pivot table, based on the first one. Thank | Excel Discussion (Misc queries) | |||
| Create interactive pivot table chart based on item selected | Charts and Charting in Excel | |||
| how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Linear Mode
