I can get a pivot to show me the top 5 items. I also need it to show me a
subtotal of all the remaining items. example:
Top item 1 = 100
Top item 2 = 90
Top item 3 = 80
Top item 4 = 75
Top item 5 = 70
all others = 85
Grand Toal = 500

Any ideas?