To many unique entries

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
I'm trying to create a pivot table based upon asset size, but I have probably > 1000 different assets sizes. I was going to group them once in the pivot table, but since I can't put it into the table first is there any other way without grouping the source data outside the pivot table since many other reports depend on this source data as is.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,057
Office Version
  1. 365
Platform
  1. Windows
How are you trying to put the asset size in the pivot table?

As a row or column item?
 

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319

ADVERTISEMENT

Anyone have an idea?
 

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319

ADVERTISEMENT

Probably
0-100,000
100,000-500,000
500,000-1,000,000
1,000,000-5,000,000
>5,000,000
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Formula in B2:<ul>[*]=CHOOSE(MATCH(A2,$D$2:$D$6,1),"0 - 100K","100K - 500K","500K - 1MM","1MM - 5MM","> 5MM")[/list]
 

Watch MrExcel Video

Forum statistics

Threads
1,118,422
Messages
5,572,010
Members
412,430
Latest member
Huuktkt
Top