Casting a "Calculated Field" into a platform role

Question

Is it possible to select two or more columns in a formula and cast it into a role for a graph (or even analysis) platform?

Excel allows you to create a calculated field as formulas in Pivot Tables.

The method is to create a formula in the PivotTable report as a calculated field.  This item will now be reflected in PivotChart reports.  This is very useful in analyzing utility cost / unit of measure when you have data at different levels and have columns containing actual amount and actual quantity.

I have been unable to reproduce this functionality in JMP.  Any ideas?

XanGregg · Answer

The way to do this in JMP is to create a new column and give it a formula property (right-click on column name and choose "Formula") with the desired formula. Then use the new synthetic column in your analyses.