When selecting and arranging dimensions there are a few constraints that apply. All of these constraints are validated and the pivot table module will provide feedback if any constraint is violated.
At least one dimension must be selected on columns or rows.
At least one period must be included in the pivot table.
Data element group sets and reporting rates cannot appear in the same pivot table.
A table cannot contain more than the maximum number of analytic records which have been specified through the system settings. The maximum number of records could also be constrained by the maximum RAM which is available to your browser. Consider making smaller tables instead of one table which displays all of your data elements and indicators together.
![[Tip]](resources/images/admon/tip.png) | Tip |
|---|---|
Pivot tables in DHIS2 are limited to a system set parameter, which controls the number of data values which can be returned. The reason for this is two fold. First, it would be easy to overwhelm the server with a very complicated request for a large pivot table. Second, the amount of data which is able to be rendered in a browser is fairly limited. If you are having problems with very large or complex tables, consider to try and reduce the number of items. It is usually more useful to have smaller, concise tables which are easier to understand and which address a particular analysis. |