can i do this in excel
Maybe...
You may be able to use data|group and outline
You may be able to use data|subtotals if your data is sorted right.
Or maybe you could use data|filter to show just what you need.
I guess it depends.
rodchar wrote:
Hey all,
Food $8.83
Restaurants $6.58
Grocery $2.25
Food is the major category and the following lines are sub-categories
(Restaurants and Grocery).
The sub-categories amounts will total on the Food line.
Is there a way to display this as the Food category being collapsable?
thanks,
rodchar
--
Dave Peterson
|