When I grouped it, it created 2 new colomns, is there a way to group it where
the drop down for Date has the breakdown....my only worry is the person that
is going to be using this report, she isn't Excel savvy, so I don't want to
have something that is going to take her a while to learn how to use...

ex.
2005
Qtr 1
Jan
1
2
Feb
Mar
etc...
"Jim Thomlinson" wrote:

So you have a date field which is actual dates. Right click on that field and
select Group. You can group by Day, Month, Quarter and/or Year. It is a great
way of aggregating your data.
--
HTH...

Jim Thomlinson


"Thomas L" wrote:

Well, I built a pivot table and it looked fine, but then my director saw it,
and she wanted an easier way to pull reports. She wants to be able to click
the date option, and have to only click on the quarter or month if she wants
to pull that report, instead of having to click each individual date for that
time period. If possible to do that with the pivot table, that will be even
better.

"Jim Thomlinson" wrote:

Nope... To the best of my knowledge if you create a cube those are your only
options. I assume that creating the pivot table directly in Excel (foregoing
the Cube) is not an option?
--
HTH...

Jim Thomlinson


"Thomas L" wrote:

Is there a way to have a data cube create an "average" in Excel? Looking at
the options, it only lists sum, min, max, & count. I really need an average
function. Is it possible to write a macro to do it w/ an average?