Hi Pepe,

Don't forget about drill-down reports. So you could do the conditions-based aggregation(s) you need in a view, make a report on it, and then drill down from any row into a related report, that would show all that your current report is showing, minus those conditions-based totals. There is precisely such an example available in the Dynamic AI Live Examples accessible from the standard Web Order entry example, report menu that ships with the DF Studio, or direclty via this link:
http://www.dataaccess.com/LiveDynamicAI

The ranking report uses a dyn-view that does the totaling. The full details how this was built are in this blog:
https://www.dataaccess.com/blog/dyna...dynamic-ai-916


Click image for larger version. 

Name:	DAI_Example_Drill_Down_Rpt_From_Rpt_Using_View_DoingItsOwnAggregations.png 
Views:	39 
Size:	134.7 KB 
ID:	13843

Also, remember, a report package/dashboard is often a solution for solving these kinds of challenges. One report shows one set of totals, another shows a different drill down path, and both are syncronized using common report filters.

Regards,
Bob