Thread: Pivot Table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SixBowls SixBowls is offline
external usenet poster
 
Posts: 26
Default 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.