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. |
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. |
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. |
All times are GMT +1. The time now is 02:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com