cancel
Showing results for 
Search instead for 
Did you mean: 

Cross-tab table shows duplicates. How to remove duplicates?

LissieDomingo03
Explorer
0 Kudos

I have a cross-tab table of terminations, and each employee has duplicates even though all fields are the same.

  • I do not have a Time Filter  in the data source to pull all Events (for terminations and hires)

In a Summary table, I am getting the right total (2):

LissieDomingo03_0-1711559847146.png

But in a cross-tab table with employee details, I am getting multiple rows for the two employees:

LissieDomingo03_1-1711559887472.png

I am using the same measure for both tables:

LissieDomingo03_2-1711560016051.png

 

lorraineant
Explorer
0 Kudos

I have the same issue on a Terminations Report. The total number is correct however, the detail data contains duplicates. I have added simple filters for Record Status = N as well as Effective Latest Change = Y. The duplicates returned for example have all the same information in all the fields except the Person ID and Name/Surname. So all the info belongs to only one employee but there are 3 rows, with 3 different Person IDs and Name/surnames. I've converted my Story report to Optimized hoping that would help, no luck. I'm also using Cross tab. Job Information is my starting table.  I'm using a Date input control using YTD.

View Entire Topic
SindhuV
Discoverer
0 Kudos

If you are pulling position table in your query, you will have to set the filter on the mdfRecordStatus = N. 

SindhuV
Discoverer
0 Kudos
Would you be able to post a screenshot of the tables in your query and also the filters for each table