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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"liem" wrote:

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







--
thanks