Duplicate values being created for same column value in a crosstab

[former_member657581]

Hi,

I am trying to create a crosstab that looks something like this:

That is there is a person 'a' occupying a room 'Room1' for a certain date 01/01/2020 and also a person 'b' occupying 'Room2' for the same date. Have a oracle table from where i am fetching the data into the report.

But instead of that it is being displayed as:

Please help me with this issue.

Thanks in advance! 🙂

[former_member657581 · Accepted solution]

I was able to solve this issue by converting the column object which i'm using in the crosstab body to a measure and setting the aggregate function to NONE.

[former_member199945]

HI,

In that case change the date format in webi report date column to DATE_TIME Format and check the results .

Thanks

[ayman_salem]

If the date has a time, this is causing the problem

To solve the problem, define a new variable for "date" with the format dd/MM/yyyy (i.e. without time) and use this variable in your cross table

[former_member657581]

No, the date column does not have a time value, it's just a simple field with datatype DATE of the format ('dd-mmm-yyyy')

[ayman_salem]

What I mean here is the original data that came from the query.

Check the data in the query and whether the date has time or not

[former_member657581]

I checked it and there is no time in the data.