Pivot Range

[knighlight]

Dear Experts,
I am working on a data which has around 100,000 lines. I am trying to create pivot for aging. Whenever I try to put aging bucket in column, I am getting "You cannot place a field that has more than 16384 items in the column area. If you want to use this field in the report, click OK, and then move the field to either the row area or page area".
Please help in creating the pivot.

[xlnitwit]

Hi,

The error means what it says- there are not enough columns on a worksheet to put a field with that many items into the column area. If you need to group it, put it in the row area, group it and then move it.