pivot table

[barim]

I would like to create pivot table that displays the names of the customers that were paid and contract expires in October. When I drag the names of customers in data field it gives me count of the customers, I want names.
How can I fix this?

Thanks.

 

[Legacy 51064]

Try moving the names to the column section of the pivot table.

 

[barim]

So, what is going in data field?

 

[lenze]

Try putting the names in the Row Field along with the dates. You can also add the names to the data field to get the count. But, PT secret, you CAN leave the data field blank.

lenze