Subscribe Bookmark RSS Feed

Formula : col sum by multi-category

jameskim

Community Trekker

Joined:

May 17, 2012

^-^)/  Hi all ~~ I need your help~!

I would like to know about JMP formula.

I knew "col sum by category1" formula as below.

Col Sum(:data, :category 1)

However, how can I use col sum formula by caregory 1 & 2 ??

I would like to use formula function only, not tablate funtion.

I appreciate your advice in advance

example below

for Col sum (by category1 & category2)

category 1category 2dataCol sum (by
  category1 & category2)
1A22+1 = 3
1A12+1 = 3
1B22 + 2 + 3 = 7
1B22 + 2 + 3 = 7
1B32 + 2 + 3 = 7
2A22 + 3 = 5
2A32 + 3 = 5
2B44 + 5 + 5 = 14
2B54 + 5 + 5 = 14
2B54 + 5 + 5 = 14
1 ACCEPTED SOLUTION

Accepted Solutions
Solution

You can put more than one ByVariable argument in the Col Sum function:

     Col Sum(:data, :category 1, :category 2)

-Jeff

-Jeff
2 REPLIES
Solution

You can put more than one ByVariable argument in the Col Sum function:

     Col Sum(:data, :category 1, :category 2)

-Jeff

-Jeff
jameskim

Community Trekker

Joined:

May 17, 2012

^느^)/ Jeff~ Thanks a lot. That's what I want~!!