Summarize multiple values by a group criteria

Technologies > User Interface Add-Ins > Grouping Views > Grouping DataSource

This example summarizes total area and total chargeable area by room standard and department:

<dataSource type="grouping" id="groupingDs_ds3">
<table name="rm"/>
<field name="rm_std" groupBy="true"/>
<field name="dp_id" groupBy="true"/>
<field name="total_area" formula="sum" baseField="rm.area" dataType="number" size="6" decimals="0">
<title>Total Area</title>
</field>
<field name="total_area_chargable" formula="sum" baseField="rm.area_chargable" dataType="number" size="6" decimals="0">
<title>Total Chargeable Area</title>
</field>
</dataSource>

View: http://localhost:8080/archibus/schema/ab-products/solutions/parts/chart/ab-ex-grouping-ds.axvw