| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Balance of pivot table data
I need to maintain an in/out/balance table showing new cases, closed cases
and the running balance each day. I have pivot table queries showing a running total of new, closed and live cases. Unfortunately not all dates appear in all pivot tables so I can't just do GETPIVOTDATA becuase there may not be a matching date. How can I select all dates up to the date in question? Example of what i have: Date Open 02/03/08 1 17/03/08 4 07/04/08 6 I want to show: Open Closed Bal Opening 378 02/03/08 1 2 377 17/03/08 4 0 381 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| monthly opening and closing balance in pivot table | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I create a running total (balance) in a pivot table? | Excel Worksheet Functions | |||
| Item wise balance in Pivot Table | Excel Discussion (Misc queries) | |||
| Item wise balance in Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
