^-^)/ 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 |
