Usings Text fields in a Pivot Table

F

FischerJustinS

I have a large amount of data that I want to use in a pivot table.

I want to sort by a field based on status. But I need each client
matched up to their representative, address, and a bunch of other
fields inc. amount. Would a pivot table be the right tool?

I want it to update when something is added to a master sheet.
 
J

Jim Thomlinson

From your limited description a pivot table could be a viable option. Pivot
Tables are designed to aggregate (Sum, count, average) large amounts of data
into a heirarchy.
 
Top