Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Rows repeating/duplicating in matrix layout

Hello community,

 

I have been struggling to fix an issue with rows duplicating in my matrix layout. Following is the snapshot of the matrix: 

Rows in column qualification are repeating for each entry of "Allocation percentage of other cost centres" column.

 

 

The data on this matrix is sourced from 3 tables - Emp, cost centres & Emp_qualification that are left joined.

Any help in resolving this issue is much appreciated.

 

thanks,

Meena

 

Need Help

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Ashish_Mathur  thanks for your suggestion. But it doesn't work as it picks up the first qualification only and still repeats for each row.

      To add to the info I provided about the matrix, all the columns are actually rows on the matrix.