Running Totals Reports

Running totals, also known as “Statistics Reports” can be created in two ways.

1. Drag and drop

There are 4 drop-able areas.

1. Select Columns
2. Total Column – Drop a column that you want to show total at the end of rows.
3. Header Column
4. Group by columns

There are 2 types of reports that are generated.

1. Total reports – Do NOT drop column inside header column

2. Product Reports – Drop column that you want in this column as header title.

2. SQL Mode

1. {citqlTotalCol|columnName|displayName}
2. {citqlGroupCol|columnName}

Use above citql to build statistics reports.

Sample Query
1. Total reports.
SELECT NAME,  {citqlTotalCol|Amount|'Total'}   FROM Product Group by date

2. Product Wise Report
SELECT {citqlGroupCol|NAME},  {citqlTotalCol|Amount|'Total'}   FROM Product Group by Name, Date