I am trying to create a sales report (not as I have been doing it - by hand).
Here's what I need: I need Sales by customer sorted decending - but I only
need the top 50 to show up. I know I could use the filter to do that,
HOWEVER, I need the Sales summary of the top 50, the summary of all the rest,
and then of course the grand total. The problem with using "filters" is that
you hide the "NOT" top 50 group. My hopes are that the "group" function
might be the answer... but I don't know enough. Put succinctly I need the
following:
1. Detail of top 50
2. Summary of top 50
3. Summary of all NOT top 50
4. Grand Total
Any help would be GREAAAAAATLY appreciated!
Oh, by the way, I just switched to Excel 2007