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

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

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

Nel post
*Yahýa* ha scritto:

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...



Now I think it can depends on *how* did you input the dates... Are they real
dates or instead are text strings? If this is the case you can't group by
month: you have to change to real dates and then grouping by month will be
ok...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

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