grouping in Excel Pivot table

L

Lim Heng Sin

currently i am using pivot table to calculate the grand
total for ageing day in my report. The ageing day are 1,
2, 3 to 6 days and > 6 days that i want to group together.
In pivot table, it can only able to calculate the grand
total like total ageing for 1 day, 2 days, 3 days.... and
go on. Is there any way that pivot table will do what i
want or you guys can suggest any other method?

I am aware of group function in pivot table but it cannot
suit my needs.

Thanks

Lim Heng Sin
 
B

BrianB

All sorts of data can be analysed by adding another column to the base
data and using the new field in the PT.

Hope this helps.
 
Top