turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Formula : col sum by multi-category

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 2, 2012 12:14 AM
(1491 views)

^-^)/ 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 1 | category 2 | data | Col sum (by category1 & category2) |

1 | A | 2 | 2+1 = 3 |

1 | A | 1 | 2+1 = 3 |

1 | B | 2 | 2 + 2 + 3 = 7 |

1 | B | 2 | 2 + 2 + 3 = 7 |

1 | B | 3 | 2 + 2 + 3 = 7 |

2 | A | 2 | 2 + 3 = 5 |

2 | A | 3 | 2 + 3 = 5 |

2 | B | 4 | 4 + 5 + 5 = 14 |

2 | B | 5 | 4 + 5 + 5 = 14 |

2 | B | 5 | 4 + 5 + 5 = 14 |

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 2, 2012 6:51 AM
(2656 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 2, 2012 6:51 AM
(2657 views)

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

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

-Jeff

-Jeff

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 5, 2012 5:30 PM
(1328 views)