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

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

Nel post news:B781E6F1-7EFA-4432-A438-CE7DC91F50D6@microsoft.com
*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 news:B781E6F1-7EFA-4432-A438-CE7DC91F50D6@microsoft.com
> *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 news:E69CF619-EAEB-420F-BEB6-3CACC0488A9B@microsoft.com
*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" <Yaha@discussions.microsoft.com> wrote in message
news:E69CF619-EAEB-420F-BEB6-3CACC0488A9B@microsoft.com...
> 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 news:B781E6F1-7EFA-4432-A438-CE7DC91F50D6@microsoft.com
>> *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
>>
>>
>>