WEBI Report is created with a structure, so I cannot modify the cells one by one but I need that.
I use [Things] where ([Things]="Thing") etc. in cells. However it looks like this, the rows are duplicated for a reason:
but i want this:
any help is appreciated. ps: i cannot give the actual data cause its a customer's report.
In your example case, it's not obvious what you want because your starting data is not clear. It's also not obvious where the #MULTIVALUE sits in the block, i.e. as a sub total. If it is a subtotal, then it suggests that [Quantity] is not defined as a measure. If that is the case, =Sum( whatever is in the multivalue cell ) will fix that, assuming it is a number and not text held as a number. If it's text, then create a new variable, called say, NumericQuantity, as =ToNumber([Quantity]) and use that instead.
Without knowing the actual structure of the block, that's the best advice that I can offer.
