Reporting: Counts in Excel and BI360
Two methods for adding a record count to your reports: using the Excel COUNT function and BI360 Grouping Count.
Jim Hummer of Solver Support demonstrates two methods for adding an item count to reports using BI360 Report Designer. This lesson is applicable to both version 4 and version 5 of Report Designer.
- Using the Excel functions COUNT and COUNTA to report on the number of items returned from an expanding row group
- Defining a cell-based Grouping based on the Count option for a non-expanding row group
- Adding filters for document type and void status