COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: phistyle on 26 Feb 2024 12:46:47 PM

Title: How to show actual data instead of repeating values in crosstab
Post by: phistyle on 26 Feb 2024 12:46:47 PM
Hello,

I'm trying to create a crosstab table to show data, but it's just repeating the data and I can't find a way to have it show distinct data without sectioning it by employee's name.  I don't want to do this since it makes filtering a pain and repeats the columns for each employee.  Example of what is happening in the image.

(https://imgur.com/a/gEZdQRT)

https://i.imgur.com/Odwmp95.png
Title: Re: How to show actual data instead of repeating values in crosstab
Post by: cognostechie on 26 Feb 2024 11:34:02 PM
Hi

It's not repeating the data. If you notice the 1st column, the names are different even if the values in all other columns/nested rows are the same and it is possible the multiple people have the same data.