Display values in a cross-table

Technologies > User Interface Add-Ins > Grouping Views> One-dimensional cross-table view

This example displays aggregated data in a cross-table format. The following data source displays two calculated values grouped by property status:

<dataSource type="grouping" id="propViewAnalysis_ds">
<table name="property"/>
<field name="status" groupBy="true"/>
<field name="area_summary" formula="sum" baseField="property.area_lease_neg" dataType="number">
<title>Area Summary</title>
</field>
<field name="property_count" formula="count" baseField="property.pr_id" dataType="number">
<title>Property Count</title>
</field>

Display values in a cross-table by setting the panel type to crossTable :

<panel type="crossTable" id="propViewAnalysis_table" dataSource="propViewAnalysis_ds">

Group data by one value

View: http://localhost:8080/archibus/schema/ab-products/solutions/parts/cross-table/ab-prop-view-analysis.axvw