Good morning,
I'm creating a graph from a pivot table in Excel 07 and I've found the Top 10 filter. It works as it should, but how can I have Excel show me the Top 10 plus all the rest of my data combined into a filed something like "Other"?
Something like:
1 - 20
2 - 19
3 - 17
...
10 - 5
Other - 23
I tried to search for this... but did not even know what to search for.
Thanks,
Steve
I'm creating a graph from a pivot table in Excel 07 and I've found the Top 10 filter. It works as it should, but how can I have Excel show me the Top 10 plus all the rest of my data combined into a filed something like "Other"?
Something like:
1 - 20
2 - 19
3 - 17
...
10 - 5
Other - 23
I tried to search for this... but did not even know what to search for.
Thanks,
Steve