>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?


try this
http://www.xs4all.nl/~foxite/downloads/gridwithtotalrow.zip