Comma Separated Values giving #Multivalue error in Webi report

[vaibhav_rathore]

Hi Experts
I have a requirement where i need to show the comma seperated IDs in a column, for this i have created some variables as below

v1=Max([Trial Id]) In ([Lot Id])

v2=[Trial Id]+","+Previous(Self)

v3=[Previous_2 _trialid] Where ([Trial Id]=[Max_Trialid])

v4=If(Not(IsNull(Previous(Self;([Lot Id]))));Previous(Self;([Lot Id]))+ ", ") +[Trial Id]

v5=[var_4_trialid] ForEach([Lot Id];[Item Id])

the columns in report are Programid, lotid, v5, itemid, region

while using this v5 in report i am getting #multivalue error for some of the trial ids where region is different and rest all are same

Expected is 

getting in report

please advise what needs to be corrected

thanks

[nscheaffer]

The Max, Previous, and Self functions operate on the rows of your query results not the value of one object on one row. Mock up in Excel and post what you want your result to be.