Pivot Table


S

SixBowls

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.
 
Ad

Advertisements

J

Jim Thomlinson

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.
 
Ad

Advertisements

S

SixBowls

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top