#Multivalue error in webi

[vaibhav_rathore]

Hi Experts

I am getting #multivalue error in webi for the measure column when used with alone item ids but if i am adding some more dimensions into the table its working well, but i dont want to show the other columns because 

1) Adding extra columns is restricting the data to sum up and is showing in multiple rows in 3-4 rows

2) Requirement is to show the summation for each item id

Please advise on the solution.

@nscheaffer your inputs will be useful

[amitrathi239]

Add those additional columns in FOREACH context in the formula/variable.