Dates and Pivot Table Help Please

  • Thread starter Thread starter Numskull
  • Start date Start date
N

Numskull

I need to group a bunch of assests under a generic heading by date.

For example, I have leases that mature on the 1st, 8th, 23, and 24th of
say Jan 04. What I want to be able to do is just show that there are
four maturing in Jan 04, 7 in Feb 04, 13 in Mar 04 etc, etc. not show
the dates individually on the pivot table. I have tried putting in the
date as text ('Jan 04, 'Feb 04 etc) but the pivot returns them out of
order and not grouped in any way. What adds to the problem is that I
have Jan 04, 05 and 06 (as well as all the months in between) and this
confuses the heck out of the table. I've also tried copying the pivot
as values to a new worksheet and this doesn't work either!! Anyone got
any idea how I can make this work???

Any help appreciated.

Regards... Num
 
What you can do is add another column to your data that
just shows month and year for each lease maturity date,
and then re-run your pivot table incorporating this new
column. If the dates are in column A, you could use this
formula:

=TEXT(A1,"mmm-yy")

HTH
Jason
Atlanta, GA
 
Jason said:
*What you can do is add another column to your data that
just shows month and year for each lease maturity date,
and then re-run your pivot table incorporating this new
column. If the dates are in column A, you could use this
formula:

=TEXT(A1,"mmm-yy")

HTH
Jason
Atlanta, GA
Click to expand...

Jason,

Thanks - worked perfectly!!!!:
 
Back
Top