pick list location

[liem]

I have a set of data with 10000 row
Div Market salesman Factor Result
1599 1501 John sales R
1599 1501 John Profit G
1599 1501 John GP% Y
1599 1501 Jeff sales R
1599 1501 Jeff Profit Y
1599 1501 Jeff GP% Y
1699 1601 Robert sales Y
1699 1601 Robert Profit G
1699 1601 Robert GP% R
1699 1601 Ron sales Y
1699 1601 Ron Profit G
1699 1601 Ron GP% R
1799 1602 Susan sales Y
1799 1602 Susan Profit G
1799 1602 Susan GP% Y
1799 1602 Sweet sales Y
1799 1602 Sweet Profit G
1799 1602 Sweet GP% Y

How can the user when they pick or use slice scale it will get back Div and
Market

Div Market --------> pick list
1599 1501

Factor John Jeff
sales R R
profit G Y
GP% Y Y


Thank
liem

 

[Luke M]

I don't completely understand your question, but perhaps a PivotTable would
work for you? Your initial criteria of picking Div and Market could be setup
as page fields, thus filtering the data you want to look at.

 

[Dave Peterson]

This seems to call out for Data|Filter|Autofilter.

You can use the dropdown arrows to choose and then only the rows that match your
criteria will be visible.

 

[liem]

I do not want to use Pivot . The example I gave to you only have 2 saleman
but if division 1599 market 1501 have 20 saleman and other 8 divisions will
have more market and more saleman.
How can i turn these data to Cross tab with the user be able pick a
Division-market it will show

Factor John Jeff Robin Diane Howard Scott ------------more salesman

sales R R G Y G G
profit G Y Y Y Y Y
GP% Y Y R R R R

--
thanks

I have a set of data with 10000 row with 8 division and 64 market and 740 saleman sample data
Div Market salesman Factor Result
1599 1501 John sales R
1599 1501 John Profit G
1599 1501 John GP% Y
1599 1501 Jeff sales R
1599 1501 Jeff Profit Y
1599 1501 Jeff GP% Y