Quick Search

Advanced Search »

Discuss (0) History

Custom Aggregates in a Matrix

RSS

Modified on Wed, Feb 17, 2010, 10:43 AM by Administrator Categorized as SSRS (SQL Server Reporting Services)

The order, top to bottom, of the matrix's row groups should be the same as in the matrix's Properties dialog (the Groups) tab.

=Iif(
	NOT(InScope("SubCodeRowGroup"))
	, "A"
	, Iif(
		NOT(InScope("ProductGroupDescripRowGroup"))
		, "B"
		, Sum(Fields!Inventory.Value)
		)
	)

Jasinski Technical Wiki