Percentage for each row

[#1]

Hello,

I am trying to find the percentage of fail for each membrane lot base on the count of fail to pass for each number of rows for the specific membrane lot number. 

[#2 · Accepted solution]

Create a new data table using

     Tables==>Split

Selecting ODStatus   as the Split variable and

Selecting N Rows as the Split Columns

You should also Select MembraneLot of Just ........ as the Group column

In the new data table you will now have a Fail and a Pass column, which you can then create a New column and using a formula of

     :Pass/(:Pass+:Fail)

to create your % value

[#3]

Two other options:

1. Tabulate: drag lot to the rows zone, status to the column zone, N to the Freq, and Row % to the cells.

2. Analyze > Consumer Research > Categorical then Responses = OD Status, X,Grouping = Lot, and Freq = N.

[#4]

Thank you so much for your help. It worked great!