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]

Sharkie

What I think Greg is suggesting is you add another column to the raw data and use that in the pivot table.

 

[Greg Truby]

Sorry - the implication is to create a "helper column" that pre-classifies the rows for you into these bins. Then just use the help-column field for your row field instead. I don't think you could do this as a calculated field since you have to pass an array into Match (or some similar Lookup-type function) and you can't use arrays or references in PT-calculated items.

{Edit - didn't see Norie's response... (always forget to look for Page 2)}

 

[Sharkie21]

Thank you very much the both of you.