grouping in Excel Pivot table

  • Thread starter Thread starter Lim Heng Sin
  • Start date Start date
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
 
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.
 
Back
Top