|
pick list location
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 |
pick list location
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 |
pick list location
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 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 -- Dave Peterson |
pick list location
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 "liem" wrote: 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 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 |
| All times are GMT +1. The time now is 07:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com