In pivot table, why all the items not showing. I have a customer analysis. In the table, there are 1200 agents. but Pivot is showing only 32 customers. Is this a intended behavior ? Or Can i configure the no of Customers to display ?