> in excel there is an option to subtotal, is it possible to do something
> similar by maybe hiding certain rows which contain subtotals and totals
> and making them visible on a click, or anything similar, any ideas?
This is one of the reasons why I sometimes hate our stunningly fast VFP-Grid. It can display tables very easily but everything above that takes an enormous ammount of effort to realize. NO, You can not do such thing by default. You will have to trick the grid by providing such data as rows in the table and work with things like DynamicForecolor and thelike using a flag-column telling You witch row is "normal data" and witch is Subtotal-data. If You allow editing You'll also need methods that track changes and modify the subtotals directly.
Subclassing or BindEvent() might help You making this possible.
Maybe You'll find something in the download-Area but I'm not sure