Usings Text fields in a Pivot Table

  • Thread starter Thread starter FischerJustinS
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table data 2
Using text values in Pivot Tables 5
Pivot table formulas 1
Pivot table, IF function, calculated item versus calculated field 1
Access #Error & Excel Pivot 0
Pivot Table - Compare Dates & calc. % 1
Formula fields in Pivot Tables? 1
about pivot table 1

Back
Top