Subtotal of a Subtotal?

[Nagasaki]

Hello,

The database I am working on now contains information for our gallery items. Each gallery item belongs to a specific collection, which is usually named after the donor. What I want to do is run a report where I can get the subtotal of each collection, and then a grand total of all the collections added together, so that at any given time I can tell what each collection is worth, and what our total collection value is.

I created a field called Total_Value which is a summary field that takes the total summary of each item's value. However when I tried to layout the report, I couldn't get it to break down the information for me the way I wanted - which is to first show me what each individual collection is valued at, and then what the total value is added all together.

I then tried to create a field that was the subtotal of all the subtotals in the Total_Value field, but it wouldn't let me create a summary field based on another summary field.

Any suggestions to get this to work? I appreciate your time.

TIA

[roadrep]

I believe the only field you are missing is this:

total_value summary sorted by collection id (assuming you have a collection id.) The calculation would look like this:

get summary (total_value,collection id)

then sort your report by collection id, showing your field total_value in the subsummary part.

works for me, hope it helps you