Grouping in pivot table
 

Hi,
Is it possible to group a table only by years. I want the total by year
only, not by months.
Please advice.
Sanjeev.

Grouping in pivot table
 

Hello Sanjeev:

One way to group by years is to add an extra column to your data and
calculate the year.

A neater way is to group by on the pivot table.

Make the pivot table. Put the months in (this is a date I assume dd/mm/yyyy
or mm/dd/yyyy).

Then right click over the header and select group and show details and
select group. From there you can select the year.

Then remove the month column from the pivot table.

Maybe somebody can show a better way to do it but it works.


--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.


"Sanjeev Raghavan" wrote:

Hi,
Is it possible to group a table only by years. I want the total by year
only, not by months.
Please advice.
Sanjeev.

Grouping in pivot table
 

Hello Martin.
I tried but I did not quite understand how I can remove only months from
pivot. When I group months and years are grouped together and I am not able
to remove months from pivot. Let me know how did you remove months alone.
REgards,
Sanjeev.

"Martin Fishlock" wrote:

Hello Sanjeev:

One way to group by years is to add an extra column to your data and
calculate the year.

A neater way is to group by on the pivot table.

Make the pivot table. Put the months in (this is a date I assume dd/mm/yyyy
or mm/dd/yyyy).

Then right click over the header and select group and show details and
select group. From there you can select the year.

Then remove the month column from the pivot table.

Maybe somebody can show a better way to do it but it works.


--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand
Please do not forget to rate this reply.


"Sanjeev Raghavan" wrote:

Hi,
Is it possible to group a table only by years. I want the total by year
only, not by months.
Please advice.
Sanjeev.