T
Tomasz Klim
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?
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?