Summary line

A measure will project (locally inside the report) unless it has been set to database delegated via Universe Designer.
In other words, just drag a measure in the table footer, and it should project (meaning: roll up locally inside the report), no new formulas are needed. This has been a basic functionality of measures for years.

See also here about SQL aggregation versus projection: diff between Select SUM (Table. Field) & Select Table. F

See also about input/output context in formuals: Dave's Adventures in Business Intelligence » Calculation Context Part I: Overview

P.S.: After all WebIntelligence is NOT cumbersome Crystal Reports :twisted: … 1:0 for Webi :+1:


Andreas :de: (BOB member since 2002-06-20)