Prev: Satisfying two conditions?
Next: Head scratchin for hours.... Help with a formula please...
From: Roland Grothe on 24 Apr 2010 14:00
I'm quite new to Pivot-Charts, so i need some help.

I use a quite simple table with Employees, segments, OrderValue, Date (only
months) and products. Every employee works in a bunch of segments

I try to produce a line chart and filter which should show me the sum,
overall, for each employee or each segment.

The emplyoyees andthe segments are page fields, the months are in the
columns and the products are in the row, which gives me an easy chart with
one line for each product. Works fine until here.

But when I select only one employee, the segment list still shows me all
segments. How is it done that the segment page field list depends on the
choice of the employee page field list?

Thanks for your help

Roland
--
The code is correct - its the syntax . . .
From: Herbert Seidenberg on 24 Apr 2010 21:07
Excel 2007 PivotTable
Dependent Page Fields.
Advanced macro method.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_24_10.xlsm
Pdf preview:
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_24_10a.pdf

 | 
Pages: 1
Prev: Satisfying two conditions?
Next: Head scratchin for hours.... Help with a formula please...