Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Worksheet Functions | |||
pivot table grouping | Excel Discussion (Misc queries) | |||
Grouping in Pivot Table | Excel Worksheet Functions |