When creating a pivot there is the option to 'Sort and Top 10'
When using this option the top 10 is created fine.
However I would like to be able to see 'the rest' as a summation.
Does anyone know of any way of doing this in one pivot table?
When creating a pivot there is the option to 'Sort and Top 10'
When using this option the top 10 is created fine.
However I would like to be able to see 'the rest' as a summation.
Does anyone know of any way of doing this in one pivot table?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks