How to show actual data instead of repeating values in crosstab

[phistyle]

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://i.imgur.com/Odwmp95.png

[cognostechie]

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.