>>Derived tables is VFP9 only feature and I could not think of a solution not involving derived tables to get your desired result in one query. Of course, we may use two views or queries (temp cursors). But I don't see a simple way to create such a view without basing it on another view and I don't like this idea.
>
>Neither could I, s'why I asked here. I'm no stranger to views of views, so it won't be too much of a problem.

Well, can you join with the view? If yes, then create one view to get one total based on one group level and in your main view join with the first view. Same idea as derived tables I showed before but instead of using derived table use an actual view.