Hi All,

I want to build a report to show the top 10 or top 5 customers plus the others as a single category in the Pivot table.

Is there any way in Pivot table to build this report. For your info i am using excel 2013 and do not have power pivot.