Formatting columns for Months, Qtrs, Yrs

S

Steve R

I deal with a lot of historical data. I want to sum this data into months,
quarters, and years. I usually use Groups to make it easier to view each so
if I want to see only yearly summaries I click the highest level, if I want
to see quarters I click the next level.

The only problem is that when I show the quarters, the years appear too
because the way they are grouped. I have tried different ways to group them
but can't find anything better.

Is there a better way to do this? Maybe without grouping? A way to name the
colums and then have a drop down choice box or something to see data by
months or quarters or years?

Please help!

Thanks,
Steve
 
M

Myrna Larson

I think you want to use a Pivot Table here.

On Tue, 12 Oct 2004 09:23:05 -0700, "Steve R" <Steve
 
Top