Problem:
Matrix reports show aggregate calculations in their cells. These calculations can be count, average, sum, minimum value, or maximum value. To see a detailed tabular report for the items included in the calculation, users can click on the cell value which is a number.
However, sometimes the cell values are not clickable.
- Example:
If users Group rows by a Date type field and select the Period such as Day, Month, or Quarter, the cell values in the report result cannot be clicked.
Root Cause:
This is working as designed. Matrix drill down is implemented by adding filters when drilling into groupings. When there is a grouping by Period, the grouping values do not correspond directly to a filter.
There are two cases in which the cell values are not clickable.
- Group rows or columns by a Date type field and select the Period.
- The row or column field is a multi-select picklist.
Solution:
In this case, users need to leave the period blank so that the numbers can be clicked.
Related Documentation:
Vault Help Documentation: Summary & Detail Views for Matrix Reports