topic Re: Get Total Qty by Group of Variables in Discussions

Get Total Qty by Group of Variables

Lino — Fri, 09 Jun 2023 19:56:06 GMT

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)?

Re: Get Total Qty by Group of Variables

jthi — Mon, 06 Sep 2021 16:41:15 GMT

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:

Re: Get Total Qty by Group of Variables

Lino — Mon, 06 Sep 2021 16:59:49 GMT

Thanks.

If I want to maintain other columns, can this still be done?

Re: Get Total Qty by Group of Variables

jthi — Mon, 06 Sep 2021 17:06:10 GMT

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: