PC Review


Reply
Thread Tools Rate Thread

Drill down via page fields

 
 
Roland Grothe
Guest
Posts: n/a
 
      24th Apr 2010
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 . . .
 
Reply With Quote
 
 
 
 
Herbert Seidenberg
Guest
Posts: n/a
 
      25th Apr 2010
Excel 2007 PivotTable
Dependent Page Fields.
Advanced macro method.
http://c0718892.cdn.cloudfiles.racks.../04_24_10.xlsm
Pdf preview:
http://c0718892.cdn.cloudfiles.racks.../04_24_10a.pdf

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Create Drill Down on Web Page Mel Microsoft ASP .NET 7 13th May 2008 03:17 PM
Drill down within a qry =?Utf-8?B?R3JhbnQ=?= Microsoft Access Queries 6 7th Jun 2006 05:49 PM
how do I replocate form fields in Word 2003 from page to page? =?Utf-8?B?WmVhaw==?= Microsoft Word Document Management 1 13th Jan 2006 04:04 PM
Sandisk Cruzer Drill Drill Drill ben_k Storage Devices 4 6th Dec 2005 01:48 AM
how do i show fields go down page instead of onto next page? =?Utf-8?B?a25nYQ==?= Microsoft Access Database Table Design 1 7th Jul 2005 12:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:25 AM.