Formatting columns to show months, quarters, OR years

S

Steve R

I deal with a lot of historical data. I usually use groups to be able to
view this data by months, quarters, and years. So if I only want to see
years I just click the highest level group. BUT...when I view the middle
group (quarters) it also shows me the highest group. I have tried different
ways of grouping but this is the best I can get.

Is there another cool way to view data like this? Maybe by naming columns
then have some sort of drop down box to choose what columns to view???

I am only an intermediate level, so please go easy...

Thanks!!!
 
S

Steve R

Thanks for the reply Frank, but I am not sure a pivot table would work...

I am dealing with financial data, so I have the Income Statement lines going
down the pages (rows). The columns are the months. I haven't used pivot
tables that much, but I didn't think this is what they were for.

Plus, I am really doing this for presentation purposes. So I want to be
able to click on something and it only show years to the client. Then if
they want to see quarters, I click on something else. I want it to present
nicely.
 
F

Frank Kabel

Hi
depending on your data a pivot table may work. As I don't know nothing
about your data layout difficult to say. You may give them a try :-9
 
Top