Choose Language Hide Translation Bar
Highlighted
switzal87
Level III

HELP NEEDED TO CREATE SUMMARY TABLE FROM A SOURCE DATA TABLE

Hello Everyone, need somebody to help me figure out how to make a summary table that looks like this:

summary.JPG

 

from a source table that looks like this:

 

CaptureSheet1.JPG

 

I attached the spreadsheet file for reference!

 

Thanks in advance! :)

 

1 REPLY 1
Highlighted
Byron_JMP
Staff

Re: HELP NEEDED TO CREATE SUMMARY TABLE FROM A SOURCE DATA TABLE

Some of the variables in the image are missing in the spreadsheet you posted.

This looks like a job for the Tabulate platform. Make sure to put your "QTY" in the frequency role.

 

JMP Systems Engineer, Pharm and BioPharm Sciences
Article Labels

    There are no labels assigned to this post.