Creating a Pivot Table

  1. 1.
    Click on the Pivot icon in the Mito toolbar.
  2. 2.
    Add a column to the Rows section to construct a key to group the dataframe by.
    1. 1.
      Optionally, to stratify the groups into individual cells, add a column to the Columns section.
  3. 3.
    Add a column to the the Values section to aggregate data within the buckets defined by Rows and Columns above.
    1. 1.
      Optionally, switch the aggregation method of the column in the Values section.
  4. 4.
    Optionally, add and configure Filters on the pivot table. Notably, these filters are applied to the source dataset before it is pivoted.