Aggregate Lines on List Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-13-2022 12:23 PM
Hello,
I want to aggregate line with the same value on a list report,
Example:
I need it to be shown as:
Notice: the FCM primary component should be only 1 aggregated line with the total value on Worked Time ...
Is it possible?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-13-2022 02:52 PM
Right click on Billable time column header -> Configure -> List Calculations.
Then right click on Primary Component column header -> Group by.
If this isn't to your liking then create a pivot report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 06:31 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2022 06:38 AM
Right click on column header Primary Component. Then click Group By