Aggregate Lines on List Report

Vinicius Luz1
Tera Expert

Hello,

 

I want to aggregate line with the same value on a list report,

Example:

ViniciusLuz1_0-1665688728566.png

 

I need it to be shown as:

ViniciusLuz1_1-1665688976218.png

Notice: the FCM primary component should be only 1 aggregated line with the total value on Worked Time ...

Is it possible?

3 REPLIES 3

Mike_R
Kilo Patron
Kilo Patron

Right click on Billable time column header -> Configure -> List Calculations. 

Mike266_0-1665697903717.png

 

Mike266_1-1665697923886.png

 

 

Then right click on Primary Component column header -> Group by.

 

 

 

If this isn't to your liking then create a pivot report

Hey @Mike_R , Yes calculation will give me a sum at the end...
What I need is to aggregate the two lines and sum the value, instead of having multiple "FCM" lines I need to shown only one

Right click on column header Primary Component. Then click Group By