Merge/Concatenate rows in SAC

[diegoviquez1293]

Hi SAC Experts !!

I'm trying to figure out a way to merge or groups columns.

Currently I'm creating a story for insp lots, however I'm having a issue with the lot status because the data set contains a row for each insp lot status.

I'm trying to merge or concatenate the different status in one single row, instead of repeating the row per status

Is there a way to achieve this?

Thanks in advance.

[William_Yu]

I don't see a way to achieve this dynamically in SAC table. The only option is to remove 'Status' from row axis, but you will lose the insight on detail status in this table.

But I guess your desired layout will only work if there is only few status per Insp Lot, concantenated display won't like nice if you have more status.