Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
I have a Pivot Table that has the following layout:
Name - Module - Month - Numerator - Denominator - % Jim - PN - Jan09 - 195 - 200 -.98 - Feb09 - 190 - 200 -.95 - Mar09 - 250 - 260 -.96 I have this data for 125 employees for each every month they are employeed. Each month the new data is added to the data tab and pivot table. I would like to look at the data for the last 400 (or some other number) of questions (denominator). In the example above, I would want just Feb and Mar. I can filter out the months to get that information by employee but I would like to get it for everyone. It could be six months for some employees and one month for others. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
From what I can tell from your question your best solution will probably be
to add a new field into your source data that will be true or false and will indicate whether that record should be included or not. That filed can be added as a filter to your pivot table. It is hard to comment further as it is not obvious what your source data might look like. -- HTH... Jim Thomlinson "SixBowls" wrote: I have a Pivot Table that has the following layout: Name - Module - Month - Numerator - Denominator - % Jim - PN - Jan09 - 195 - 200 -.98 - Feb09 - 190 - 200 -.95 - Mar09 - 250 - 260 -.96 I have this data for 125 employees for each every month they are employeed. Each month the new data is added to the data tab and pivot table. I would like to look at the data for the last 400 (or some other number) of questions (denominator). In the example above, I would want just Feb and Mar. I can filter out the months to get that information by employee but I would like to get it for everyone. It could be six months for some employees and one month for others. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
My source data is very similar to the pivot table.
Name - Module - Month - Numerator - Denominator The source data is updated each month and never purged. "Jim Thomlinson" wrote: From what I can tell from your question your best solution will probably be to add a new field into your source data that will be true or false and will indicate whether that record should be included or not. That filed can be added as a filter to your pivot table. It is hard to comment further as it is not obvious what your source data might look like. -- HTH... Jim Thomlinson "SixBowls" wrote: I have a Pivot Table that has the following layout: Name - Module - Month - Numerator - Denominator - % Jim - PN - Jan09 - 195 - 200 -.98 - Feb09 - 190 - 200 -.95 - Mar09 - 250 - 260 -.96 I have this data for 125 employees for each every month they are employeed. Each month the new data is added to the data tab and pivot table. I would like to look at the data for the last 400 (or some other number) of questions (denominator). In the example above, I would want just Feb and Mar. I can filter out the months to get that information by employee but I would like to get it for everyone. It could be six months for some employees and one month for others. |
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) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |