How to create a calculated column similar to pivot table in Excel?
Aug 14, 2013 4:07 PM(7215 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