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
- :
- Discussions
- :
- How to create a calculated column similar to pivot table in Excel?

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 14, 2013 4:07 PM
(4376 views)

I want to use graph builder to slice and dice attrition data. In Excel I would use what is called a calculated field within a pivot table.

My data would look like the attached, where I can select any field as row(s)s or column(s) and the attrition rate would update dynamically since its a caculated field.

How do I do this in JMP? I tried HC/TER and sum(HC)/sum(TER). I did this in the data detail as as a separate column. Neither worked since they only caculate once at the individual level. I need something that will

perform the caculation on update.

1 ACCEPTED SOLUTION

Accepted Solutions

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

I don't think JMP can do exactly that, with an arbitrary formula evaluated over the dynamic grouping.

If you know the grouping and can create a formula, be sure to use the Col functions and provide the grouping column(s) as BY variable(s): Col Sum( :HC, :KeyEE ) / Col Sum( :TER, :KeyEE )

Otherwise you can compare sums (inferring the ratio) with a table in Tabulate:

Or graphically in Graph Builder:

1 REPLY 1

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

I don't think JMP can do exactly that, with an arbitrary formula evaluated over the dynamic grouping.

If you know the grouping and can create a formula, be sure to use the Col functions and provide the grouping column(s) as BY variable(s): Col Sum( :HC, :KeyEE ) / Col Sum( :TER, :KeyEE )

Otherwise you can compare sums (inferring the ratio) with a table in Tabulate:

Or graphically in Graph Builder: