HELP NEEDED TO CREATE SUMMARY TABLE FROM A SOURCE DATA TABLE

Question

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

from a source table that looks like this:

I attached the spreadsheet file for reference!

Thanks in advance! :)

Y1 SAMPLE DATA.xlsx

Byron_JMP · Answer

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.