BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
switzal87
Community Trekker

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! :)

 

0 Kudos
1 REPLY 1
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