COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Falcon on 10 Jul 2024 02:47:16 PM

Title: How to create a distinct count and row count on the top of the report
Post by: Falcon on 10 Jul 2024 02:47:16 PM
Total novice here....I have a report that is a simple list of work orders and by design one work order can be in multiple rows in the list. On the top of the report, I want to add 2 simple totals:

Distinct Count of Work Orders
Row Count

On the top of the report, I was able to insert a text item for the a label, but I cannot get anything to sit beside it. What is the trick to adding these type of calcs to the top?

When I try to insert a query calculation, it ends up looking like multiple rows and it is beneath the text item that I created.

What is the trick for doing this?

Thanks!

Title: Re: How to create a distinct count and row count on the top of the report
Post by: dougp on 10 Jul 2024 04:55:16 PM
QuoteWhen I try to insert a query calculation, it ends up looking like multiple rows

I'm guessing you dropped the query calculation on the page?  ...and a list was created?

Try using a singleton.
Title: Re: How to create a distinct count and row count on the top of the report
Post by: Falcon on 11 Jul 2024 12:26:57 PM
Thank you.  I created a block and then inserted two singletons.