Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks.
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?