Thread: Pivot table - show top 20 and group remaining data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sarah (OGI) Sarah (OGI) is offline
external usenet poster
  
Posts: 128
Default Pivot table - show top 20 and group remaining data
Is there any way of showing the top 20 entries in a pivot table, then
grouping the remaining entries as one, i.e. 'Other'.
Reply With QuoteReply With Quote