How to group a row field in a pivot table? [split]

hai dear colin legg,

i have gone through the pivot table example (http://www.xtremevbtalk.com/showthread.php?t=317087), please let me know how the grouping is done, i have been using the pivot table but this example is something different for me.

i once again request you to explain how to group the data as in this example...

with regards
ashok


Please start your own threads to ask your own questions, thank you.

hai dear colin legg,

i have gone through the pivot table example, please let me know how the grouping is done, i have been using the pivot table but this example is something different for me.

i once again request you to explain how to group the data as in this example...

with regards
ashok

Hi ashok,

To remove the grouping, right click on the row field > group and show detail > ungroup.

To add the grouping back again, right click on the row field > group and show detail > group > Starting At = 0, Ending At = 2500, By = 500 > OK.

thanks dear colin legg..

this is of great help and learning for me

thank you once again

ashok

Hi ashok,

It is particularly useful when you have dates and times, because you can group them by days, months, years, etc...

hi colin legg

this information is very helpful to me in my routine work....

once again thanks to you...

ashok