If they are dates group by month and by year

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Yahýa" wrote in message
...
Hi Franz Verga,
Thanks for your response. But my problem is not solved. Let me explain it:
when i have data of same months of different years in a pivot table (eg:
jan.05 and jan.06) and when i group the date column/field by "Month" then
the
data of both the years are summed up under "January". Now how do i show it
in
different groups? Hope you got my point...

Thanks in advance,
Yahýa.

"Franz Verga" wrote:

Nel post
*Yahýa* ha scritto:

how to change date formating-grouped by month in pivot table


Hi Yahýa,

On your pivot table, right click on a date (mayebe here is a month's
name...) click on Group an Show Detail and then you will have your
option:
Show/Hide details, Group/Ungroup.

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy