^-^)/ Hi~ I need your advice.
I would like to know about JMP formula.
I knew "col sum by category 1 & 2" formula as below.
Col Sum(:data, :category1, :category2)
However, how can I use col sum formula by category2 with exclude function ?
I do not want to delete raw data, but I want to calculate col sum with exception.
Combination with other formula function would be OK.
I appreciate your advice in advance
catrgory1 | catrgory2 | data | Col sum(:data, :category1, :category2) with exclude "O,T,Y" from category2 |
A | O | 1 | 2+3+4+5=14 |
A | P | 2 | 2+3+4+5=14 |
A | Q | 3 | 2+3+4+5=14 |
A | R | 4 | 2+3+4+5=14 |
A | S | 5 | 2+3+4+5=14 |
A | T | 6 | 2+3+4+5=14 |
B | U | 7 | 7+8+1+3=19 |
B | V | 8 | 7+8+1+3=19 |
B | W | 9 | 7+8+1+3=19 |
B | X | 1 | 7+8+1+3=19 |
B | Y | 2 | 7+8+1+3=19 |
B | Z | 3 | 7+8+1+3=19 |