Group By: When using Show Total Rows and you group by the aggregated attribute, the totals disappears
search cancel

Group By: When using Show Total Rows and you group by the aggregated attribute, the totals disappears

book

Article ID: 265948

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The aggregated number is not displayed on the 'Totals Row' when that field is used in the 'Group By'. 

Steps to Reproduce: 

  1. Go to projects workspace 
  2. Switch to grid and have the following columns: Name, ID, Manager, Active 
  3. Now in the View options, enable Show Total Rows 
  4. Notice the Total as the first row in the grid and a summation for Active 
  5. Now Group By Manager, then group By Active 

Expected Results: The value aggregation total amount should be displayed on the 'Totals Row' when that column field is also used as a 'Group By' field. 

Actual Results: The value aggregation is not displayed in the 'Totals Row' when that column field is used as a 'Group By' field. 

Workaround: None. 

Figure #1: Totals appear when grouping by another, non-aggregate field. 

  

Figure #2: Totals DO NOT appear when grouping by the 'Active' field (an aggregation type of field).   

     

Environment

Release 16.1.2 

Cause

DE69821 

Resolution

There is a limitation when using Group By for showing the Aggregation in the column for a field that is included in the Group By configuration. Therefore, the use case described is working as per the current limitations. As part of reviewing the use case for this reported issue, it was discovered that if the field was removed from the grouping, the column for that field did not show the Totals Row. This is what was fixed.