Re: Calculated "virtual" rows

[Rick James]

Suggest you take it in stages. Perhaps use "temporary tables" for the extra stages. Example: computing the admin costs.

Do you have the hierarchy depth of each field with the field? That might help in this approach to the "rollup":
Calc level 6 from level 7 data;
Calc level 5 from level 6 data;
etc

The bottom line is that the complexity of the data is more than can easily be handled in SQL. Or, to rephrase, the complexity of the data will have to be mirrored in the complexity of the SQL.

You probably should be using some programming language (Java, Perl, PHP, VB, ...) for the "business logic", and let the database be "dumb storage". It is messy to do complex logic in SQL.