![]() |
How do I see top items
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? |
All times are GMT +1. The time now is 01:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com