 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004Pivot
I have a pivot linked to a query with name of the client in the row items and sum of sales in the data items. It is sorted by sales. I'd like to show only the top and bottom 20 people. Is there a way to do it in the pivot? ya simple de-select the items u dont wish to show!  SignatureHope it Helps! Jim India > I have a pivot linked to a query with name of the client > in the row items and sum of sales in the data items. It > is sorted by sales. I'd like to show only the top and > bottom 20 people. Is there a way to do it in the pivot? Sorry - to simple - I've got dynamic data so it's constantly refreshing. This means I'd have to choose the ones I want to show everytime it refreshes. I need it to just show the Top n(%) like in a query. >-----Original Message----- >ya simple de-select the items u dont wish to show! [quoted text clipped - 5 lines] > >. In the Pivot Table, double-click on the Client field button Click the Advanced button For 'Top 10 AutoShow', select On For 'Show', select Top or Bottom, then set the number of items Click OK, click OK > I have a pivot linked to a query with name of the client > in the row items and sum of sales in the data items. It > is sorted by sales. I'd like to show only the top and > bottom 20 people. Is there a way to do it in the pivot? SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html Perfect! Thank you so much. >-----Original Message----- >In the Pivot Table, double-click on the Client field button [quoted text clipped - 7 lines] >> is sorted by sales. I'd like to show only the top and >> bottom 20 people. Is there a way to do it in the pivot? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.