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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot table grand total location 1
Referencing a pivot tables Grand Totals Column 1
pivot table excel 2
Pivot Table - 3
Group in Multiple Pivot table 1
Grand Total for Rows not Working in a Pivot Table 1
Pivot Table Count 1

Back
Top