Pivot Table Chart

H

Hojo

We are attempting to create a chart from a pivot table. We only want to
chart the last 6 months. However, when you select August, September,
October, November, December, and January. it wants to pull data in from
January 2007 as well as 2008. Is there another way to tell it only Jan of
2008.
 
R

Roger Govier

Hi
Can you have Year as a Page field?
If you haven't done so already with your Date field, then under Group and
Outline>Group>select Year as well as Month
Then drag Year to Page field and use dropdown to select 2007.
 
Top