To many unique entries

[Sharkie21]

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.

 

[Norie]

How are you trying to put the asset size in the pivot table?

As a row or column item?

 

[Sharkie21]

As a row item.

 

[Sharkie21]

My bad there's 21300 different Asset Values.

 

[Sharkie21]

Anyone have an idea?

 

[Greg Truby]

What's your grouping logic? How many groups?

 

[Sharkie21]

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

 

[Greg Truby]

book1.xls
	A	B	C	D
1	Values	Group Labels		Bins
2	12	0 - 100K		0
3	120,000	100K - 500K		100000
4	555,000	500K - 1MM		500000
5	1,250,000	1MM - 5MM		1000000
6	5,550,000	> 5MM		5000000
b

 

[Greg Truby]

Formula in B2:<ul>[*]=CHOOSE(MATCH(A2,$D$2:$D$6,1),"0 - 100K","100K - 500K","500K - 1MM","1MM - 5MM","> 5MM")[/list]

 

[Sharkie21]

How do I incorporate that into my pivot table?