positve 'top 10' and positive 'others'

[karensmith]

Requriement is to duplicate excel table that show top ten Sales Gap totals for customers with a positive gap. Then show total of other customers with positive sales gap and then total of all positive sales gap customers. The Gap CR is based on positive customers only and not total sales.

The second half to create the same exact structure for negative sales gap customers. Here is an example of the table. Has anyone ever developed such a table.

My question is how do I just focus on customers with positive vales and exclude the rest. I can figure out how to the first 'Positive Top 10 Total by using a aggr dimension in a pivot table, but I can figure how sume the other two total lines.

Thank you in advance!