Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Suppress subtotals/aggregation for certain columns in a matrix

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/ProjectCreated DateStageEst. FeeEst. Profit
Civil Engineering  868,00086,800
        City of ABC  350,00035,000

                Project 1

1/1/2025Fee Negotiations150,00015,000
                Project 22/5/2025Proposal Prep.200,00020,000
        City of XYZ  518,00051,800

                Project 1

2/8/2025Lead310,00031,000
                Project 23/4/2025Selected208,00020,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.

Status: New