I am creating a Daily Labor Report within IBM Cognos Connection, hosted through UltiPro software. I have all fields and groupings laid out exactly how I want them, only I want there to be totals to show within the header of each grouping. For example, I want to show the total hours worked within each Shift grouping and each Department grouping. Within the data table, I added in a summary row with aggregates for all the necessary columns (Scheduled Hours, Regular Hours, Overtime Hours, etc), but it only shows at the very bottom of the report that aggregates up the entire day's numbers across all departments and shifts. Any ideas as to how to accomplish showing the aggregates within each grouping?
1
votes
By grouping, do you mean the report is "sectioned"? If so this is likely a case for a second query linked via a master-detail relationship. If not, could you post some sort of visual representation of what you're describing?
– toddsonofodin
Users without many points cannot post images.
– Damienknight
I would gladly add an image to better explain the situation, but I do not have enough user points to be allowed to post images.
– user2932503
1 Answers
0
votes
If I understand everything, try this:
Delete your current summary.
Add footers to each of your groupings.
Click the Summarize button. That should place summaries in each of your footers.
Unlock the report (the little padlock icon on the toolbar).
Drag your summaries from the footers to the corresponding headers.
