Pivot tables with pre-counted dates
 

Hello

I wish to build a pivot table, based on a simple data sheet, with the
following columns:
a) name
b) type
c) price
d) date
e) place

My problem is that "date" column contains individual dates in rows, for
example 2003-07-29, 2003-07-30, 2003-07-31, 2003-08-01 etc., and this is
displayed in the pivot table. What I exactly want is to pre-count these
dates into months (2003-07, 2003-08 and so on), of course with aggregating
individual prices withing a single month.

I know I can write a macro, that will generate another column and treating
the date as string, cut the last 3 chars, but I need a dynamic pivot table,
don't want to use such hacks.

Is there a way to do this?

Pivot tables with pre-counted dates
 

You can group the pivot table dates by month, as described he

http://www.contextures.com/xlPivot07.html

Tomasz Klim wrote:
Hello

I wish to build a pivot table, based on a simple data sheet, with the
following columns:
a) name
b) type
c) price
d) date
e) place

My problem is that "date" column contains individual dates in rows, for
example 2003-07-29, 2003-07-30, 2003-07-31, 2003-08-01 etc., and this is
displayed in the pivot table. What I exactly want is to pre-count these
dates into months (2003-07, 2003-08 and so on), of course with
aggregating individual prices withing a single month.

I know I can write a macro, that will generate another column and
treating the date as string, cut the last 3 chars, but I need a dynamic
pivot table, don't want to use such hacks.

Is there a way to do this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html