MultiValue Measure

[Former Member]

Hi

I  have created a multivalue measure for Product

Customer       Account    Product

A company     1               p1,p1

A Company     2               p1,p1

I am getting duplicates in the  multi value measure  product( i chosen aggregation as SUM).

I want below output instead, how can i get it.

Customer       Account    Product

A company     1               p1

A Company     2               p1

Thanks

[Former Member]

Hi Vishal,

You always want to show the first value of product?

if yes then create a variable as

=substr([product];1;Pos([product];",")-1)

[amitrathi239]

Product values are coming directly from object or you have created some  variable at webi level?

What is the expected product length ? if two only then use substr to get the first two character.

=Substr([Product];1;2)

[Former Member]

Product values are coming from object  and length is 100 charcter

Product name are p1  XXXXX, p2XXXX

[amitrathi239]

your product values are string type.you can not apply sum function on product