PivotTable ignores format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tobias Weber - 26 Sep 2008 21:39 GMT

Hi,
one of my columns contains a full date but is formatted to only display
year and month. When using it in a PivotTable Report this reverts to the
default format, and rows are grouped by day instead of year>month :(

Can I circumvent this by modifying some formula in the report?

Signature

Tobias Weber

Reply to this Message

Fergal Condron - 29 Sep 2008 18:54 GMT

Hi Tobias,

Can you be more specific about your problem? I played around with this and
when formatting column date data as month/year the pivot table retained the
formatting.

If it also works could you send me a file I could take a look at to figure
out what is going on? My email is: fercon@microsoft.com

Thanks!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.

On 9/26/08 1:39 PM, in article
towb-8394CC.22391626092008@news.individual.de, "Tobias Weber" <towb@gmx.net>
wrote:

> Hi,
> one of my columns contains a full date but is formatted to only display
> year and month. When using it in a PivotTable Report this reverts to the
> default format, and rows are grouped by day instead of year>month :(
>
> Can I circumvent this by modifying some formula in the report?

Reply to this Message

Tobias Weber - 30 Sep 2008 08:54 GMT

> one of my columns contains a full date but is formatted to only display
> year and month. When using it in a PivotTable Report this reverts to the
> default format, and rows are grouped by day instead of year>month :(

Found the problem: everything works as expected as long as ALL rows have
a date. If there's one with a blank cell in that column everything
reverts.

Signature

Tobias Weber

Reply to this Message

Mac Forum / Applications / Excel / September 2008

PivotTable ignores format