How to Merge Multiple Rows in webi using BEx query

[system]

Hello,

here i have two different columns one with Date and Status

Based on the status date should display in different columns
one status can have multiple dates.
single status n Date display good in webi… when we have multiple dates I am getting #multivalue Errror…

I tried create Details Objects in webi but no luck…

Please reply ASAP , its urgent ticket … how can i achieve the Solution…

I am getting below format data
Trip # Date1 Date 2 Date 3
11------1/1/13
11 ----- ------- 1/2/13
11 ------------------------- 1/3/13
I want achieve as below …

Trip# Date1 Date 2 Date3
11 1/1/13 1/2/13 1/3/13

Thanks
merago

---

merago (BOB member since 2013-09-04)

[system]

Moderator note:
if indeed it was so urgent then do hire an expert or get with SAP support.
Review this topic for some suggestions, thanks.

---

Andreas (BOB member since 2002-06-20)