How to Concatenate one field based on another one field in Webi report

[HiShilpiRanjan]

Hi All,

I have a requirement in Webi Report.

I am sharing the png screenshot (as Excel is allowed to share here) and explaining further details below:

I need to concatenate field named "SPA_ID"(green color column) as per Doc_No(orange color column).

Basically, I need a new column Concat_SPA_ID that u see in blue colour.

I have manually entered values for "Concat_SPA_ID" field (Blue color) only till row number 14, to show u exactly what is required.

I tried the variable below, but not helpful:
=[SPA_ID] + "," + Previous(Self;([DOC_NO]))

It would be of great help if u can help me achieve this blue colored field "Concat_SPA_ID"🙏.


Plese let me know if any more details required.

Regards,
Shilpi