ExcelBanter - Pivot Table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Table (https://www.excelbanter.com/excel-worksheet-functions/38843-pivot-table.html)

dipsy

Pivot Table

I have Pivot Table - the data on project sums up to $100.00. The Major
Initiatives from this data sum up to $70. The number of Major Initiatives is
just 7. The other projects sum up to 30 - but their number is 120.

I want to show the 7 major initiaitves and show the total for other without
showing the 120 initiatives. Can someone please help?

Thanks.

All times are GMT +1. The time now is 06:06 AM.