Why does one singel records occupy one line that duplicate the rows?

Steven Sun shared this question 5 years ago
Answered

Hi,

Can anyone help guide me on this? I've tried suppress duplicate which just combine the rows in the first column, instead of combine the value of each line. There are calculated fields, and I've replaced 'else 0' with just 'end', to save some zeros.

Please note even one cell has value and the others only have Zero, it'll make one row of record.


Thanks in advance.

Replies (1)

photo
1

By use aggregation on each column, I've eliminated all redundant row.

Leave a Comment
 
Attach a file