Why does one singel records occupy one line that duplicate the rows?
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.
Hi Steven,
Thank you for your question. Please reference this video for instructions on column formatting: https://community.yellowfinbi.com/knowledge-base/article/suppress-duplicates, where you may need to select "Summary" > "Sub total" from the Column Formatting settings as shown in the video to view the aggregated total for each field being suppressed.
Let me know if this helps answers your question.
Regards,
Simon
By use aggregation on each column, I've eliminated all redundant row.
Hi Steven,
It sounds like your problem is solved!
Let me know if there is anything else we can help with, regarding this issue or any other.
Regards,
Simon
Comments have been locked on this page!