ktQueBIT
asked on
Issue with totals in a Cognos 10.2.1.1 list report.
I am working with Cognos 10.2.1.1 and I am trying to create a Summary table using a list report at the top of another list report that is a detail report to match the summary. What I would like to do is get a distinct count of the different courses each professor teaches for the Fall and Spring Semesters. I have the line level detail working correctly in the detail list and the course counts by professor by term are all working. However when I try to just display the totals (summary) for each professor for each term (essentially just removing the line level detail from the detail report) I cannot get the totals to work. It looks like it is pulling the professors entire teaching history for Fall and Spring terms. I am just trying to get the specific course load for the most recent Fall and Spring. Does anyone have any suggestions on ways I can do this. I can upload a sample report or screenshots if needed for clarification. Thanks.
It seems like you should be able to create a pivot table and use Filter Controls to limit the data set to the desired terms, assuming that the data is in a common cube.
Have you tried using Pivot Table functionality within Cognos?
Have you tried using Pivot Table functionality within Cognos?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The solution gave me exactly the output that I wanted in the report. I got a summary table based on the detail data displayed in the detail report below the summary table at the top.
count([courses] for [professor])
if the model is set up correctly.