Drill down via page fields

R

Roland Grothe

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
 

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