Unique Items in Pivot table

T

TGries

New Member
Joined
Feb 5, 2003
Messages
13
I have 27,500(or so) lines of data, including customer names. I am trying to use the Pivot Table to show me how many transactions for each customer. I get an error telling me "A field in my source data has more unique items than can be used with the Pivot Table feature".

Is there a better way I can get a count of how many unique customers I have in my data, without converting everything into MS Access Table?

Please help...
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Sort by date Sort by votes
Hi,

Use Data, Subtotals to get a subtotal of your data. You can specify the Count function to get a count of records for your data.

Post back if you can't get something to work.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Creating Unique list from Customer Order Amount, Customer Name and Order Identifier using the Unique function
2
Replies
11
Views
395
etaf
etaf
H
  • Question Question
VBA code to open an excel workbook, Refresh the query (PQ), once it has finished running, save and close the workbook
Replies
2
Views
1K
hananak
H
K
  • Solved
Use 'Unique', 'Filter' and 'If' statements.
Replies
7
Views
390
Fluff
Fluff
S
  • Solved
Pivot Table Macro
Replies
4
Views
453
SCPbrito
S
B
  • Question Question
Removed Feature: Pivot Table
Replies
0
Views
246
bec98
B

Forum statistics

Threads
1,225,156
Messages
6,183,240
Members
453,152
Latest member
ChrisMd

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top