Created:
| Last Modified:
Hi,
Below my data in spreadsheet, I attached the file in JMP as well. I am trying to create the last column with formula/code , Total Defect (Same Part# and Defect) with merged cell, based on the data on the left. This is can be done in spreadsheet.
I tried to use Tabulate(). It is not work as well.
Can we do this JMP, merged the cell to show total sum qty?, or,
Without the merging cells, is there other way we can get the total defect (same part# and defect)?
1 ACCEPTED SOLUTION
Accepted Solutions
There are no merged cells in JMP like in a spreadsheet because JMP isn't one . Below are some examples how JMP can do this:
Formula:
Select Part# and Defect columns, right click on the column header and select group by:
Right click on Total column header:
Result:
Summary table, if you leave this linked to original table, they are also interactive:
Tabulate:
There are no merged cells in JMP like in a spreadsheet because JMP isn't one . Below are some examples how JMP can do this:
Formula:
Select Part# and Defect columns, right click on the column header and select group by:
Right click on Total column header:
Result:
Summary table, if you leave this linked to original table, they are also interactive:
Tabulate:
The first option should let you do that as it just creates new formula column. Or you could update the data back from Summary table:
