merge rows or aggr

[MK9885]

Hi,

I've a requirement to get combine count or aggr count by dimension.

Ex:

Serial#	Fac ID	Process#	Machine ID	Month	Year	Location	Mod	Net	<12	Between 12 & < 24	Between 24 and less than 48
1.1	21	225190.6	12345	8	2019	NYC	AC	1	1	0	0
1.1	21	478036.5	12345	8	2019	NYC	AC	1	1	0	0
1.1	21	745213.1	12345	8	2019	NYC	AC	1	0	1	0
1.1	21	895231.8	12345	8	2019	NYC	AC	1	0	0	1
							Total	4	2	1	1

  I'd like to merge or combine the count of <12 column

Machine ID is same so first 2 rows which gives me individual values as 1 & 1 should be rolled up as 2. But Process# is different that's why I couldn't get it to work.

So where ever there is a same Machine ID, roll up the counts to give it as 2 or 3 or 4 but not individual 1 or individual rows.

if anyone can help?

@sunny_talwar 

Thanks.

[sunny_talwar]

What exactly is your expression that you have used for <12? May be you need to add TOTAL <[Machine ID]> to get 2 and 2 on the first two rows?