How to aggregate multiple rows in a single rows in a straight table

[abc_18]

Hello everyone,

How can I aggregate the values where I can see "- Other" in a single row and this needs to be handled at chart level only because have multiple measure against those values being calculated using chart expression. 

X-Y	a	x	y	z	q	w	e	r	t	y
-		126	0	41	75	8	.41%	0.03%	0	8
Data related to order - X,Y,Z	a-2	45	0	0	15	1	.05%	0.00%	0	1
Order placed - A,B,C	N/A	33	0	20	90	8	.39%	0.03%	0	8
22.2.2 - Other		24	0	0	2	0	.01%	0.00%	0	0
22.2.3 - Other		7	0	5	0	0	.02%	0.00%	0	0
22.3.1 - Other		8	0	0	3	1	.01%	0.00%	0	1
22.4.0 - Other		9	0	8	3	0	.04%	0.00%	0	0
22.5.1 - Other		7	0	0	2	0	.01%	0.00%	0	0
22.5.2 - Other		6	0	2	3	0	.02%	0.00%	0	0
22.6.5 - Big order	a-3	4	0	0	1	0	.%	0.00%	0	0
22.6.7 - 450GH	a-5	4	0	0	0	1	.%	0.00%	0	1

[mdmukramali]

Hi,

can you try to add a calculated dimension in the straight table something like below.

=IF(WildMatch([X-Y],'*Other'),'OTHERS',[X-Y])

it will group all the values which contain Other.

[West69]

You can concatenate rows into single string using COALESCE method. This COALESCE method can be used in SQL Server version 2008 and higher. All you have to do is, declare a varchar variable and inside the coalesce, concat the variable with comma and the column, then assign the COALESCE to the variable.
AvalonAccess

[abc_18]

Hi, Expectation is as below:

We need to show these Other values as comma separated not like it will go to one column as "Other".

Before'-' numbers are different so we need to combine all those value in one row and expressions also need to be aggregate. For ex have done for column x (24+7+8).

X-Y	a	x	y	z	q	w	e	r	t	y
-		126	0	41	75	8	.41%	0.03%	0	8
Data related to order - X,Y,Z	a-2	45	0	0	15	1	.05%	0.00%	0	1
Order placed - A,B,C	N/A	33	0	20	90	8	.39%	0.03%	0	8
22.2.2 - Other, 22.2.3 - Other, 22.3.1 - Other		39	0	0	2	0	.01%	0.00%	0	0