It is great that you can customize how lifetime giving, total committed and total received calculate on the donor's file, but unfortunately, you cannot get the same level of information out of queries, so you could pull those same calculations (including things like exclusion of pledge write offs) by fund or by a date range.