If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|