During yesterday’s Mastering JMP live Webcast on Shaping Your Data, one of the JMP capabilities presenter Jeff Hawes demonstrated was Tabulate (Tables>Tabulate). Here is a tidbit that folks found interesting.
Jeff: Tabulate is one of the data management tools in JMP. It is akin to a Pivot Table in Excel, but more interactive. By dragging and dropping into zones on a template, you create a multidimensional table.
Question: What is the advantage of using Tabulate instead of Summary (Tables>Summary)?
Jeff: There are two main differences. First, Summary only summarizes for rows - and the table is made up of records in rows with single-header columns. With Tabulate, you can group your rows and columns into subcategories and nest factors within multiple categories. For example, you can build subcategories like vehicle size for each car brand.
Second, Summary provides a data table, whereas Tabulate is a an interactive report that responds to dynamic, animated data filtering. In this example I apply the data filter to highway mileage.