Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Should I use Pivot Table or something else?
Hi all,
I'm generally a novice at using excel, so at the moment I'm stumped at figuring out exactly how to do what I need. Here's the problem - I'm looking at summarizing a small portion of data that is from a larger set of data. This data is updated and added to each week (meaning there is a new column of data for the latest week). My solution at the moment is to use a pivot table and filter down to what I need. Question: But how do I just add the new weeks of data without recreating my pivot table? Also - There is a couple of groupings that I would like subtotals for. Is there a way to select just a couple of rows of data in the pivot table and subtotal that? Or should I be using something completely different? Right now I have two fields that form the rows, so the number of rows will likely change (so I don't think just using lookup would work well for this). Thanks for any help you can provide. Tina |
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) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |