For certain types of columns, such as text columns, it is often the case that one does not want ANY value to show in the subtotal row for that particular colmn (value), Currently, you are forced to select an aggregation type like count, count distinct first, etc. There should be a "None" option so that when records are grouped/rolled up, you can indicate that a particular field should simply not be aggregated at all. Example: Dept/Client/Project Created Date Stage Est. Fee Est. Profit Civil Engineering 868,000 86,800 City of ABC 350,000 35,000 Project 1 1/1/2025 Fee Negotiations 150,000 15,000 Project 2 2/5/2025 Proposal Prep. 200,000 20,000 City of XYZ 518,000 51,800 Project 1 2/8/2025 Lead 310,000 31,000 Project 2 3/4/2025 Selected 208,000 20,800 Note how we have three levels of grouping in this matrix, the department, client, and the "detail" level the project. For each project, it makes sense to show values for all the columns. When rolling up to the Client level, while it does make sense to aggregate (sum) the numeric phases, in most cases it is undesirable to show any subtotal value for, in this case, the date or text columns namely Created Date and Stage. I realize that one could include those values as matrix-rows instead of matrix-values, but typically you do not want to group your records by these fileds and just want to display their vales at that lowest level.
... View more