Multiple Rows in one row

[Viji2022]

Hi,

I have report data in below format

SONum----TranscationID------Status
1234-------234----------Try
1234-------567----------Try
1234-------890----------Try
1234-------967----------Complete

After adding below measures and Dimension in report level getting data in three rows

FirstID (Measure)
= MIN(TranscationID) IN SONUM

FinalID (Measure)
= MAX(TranscationID) IN SONUM

FirstStatus (Dimension)
= Status where (TranscationID = FirstID) IN SONum

FinalStatus (Dimension)
= Status where (TranscationID = FinalID) IN SONum

SONum----FirstID----FinalID—FirstStatus----FinalStatus
1234-----234---------967----------Try---------------------
1234-----234---------967-----------------------Complete
1234-----234---------967---------------------------------

But I want in just one row

SONum----FirstID----FinalID—FirstStatus----FinalStatus
1234-----234---------967----------Try----------Complete

any suggestion will be helpful

thanks in advance

[MarkP]

Instead of just Status, use Max(Status) for your FirstStatus and FinalStatus dimensions.

[Viji2022]

Thanks Mark it worked