Windchill report "Group by" rows function
Version: Windchill 12.0
Use Case: I have a report that lists out a number of ECNs and how many reworks (trip count) per ECN there were. The table view of the report shows a new row for each incrementing trip count value. "Group by" doesn't seem to do the grouping by rows to consolidate the results.
Description:
The report template lists out the ECN number for a time range with it's trip count (number of reworks). The table itself has a row for each incremental value of the trip count.
Something like this:
| ECN Number | Date | Trip count |
| ECN-12345 | 1/2/23 | 1 |
| ECN-12345 | 1/3/23 | 2 |
| ECN-12345 | 1/5/24 | 3 |
Is there a way in the report template to group the rows by the ECN number so that for the example above I just get a single row like this:
| ECN Number | Date | Trip count |
| ECN-12345 | 1/5/23 | 3 |
Ideally I'm looking for a way of doing this without exporting out the table and then doing this in PowerBI (which works just fine).