Pivoting Data

Spreadic can create a pivot table directly from a model. That means you don’t have to load a large amount of data into a sheet (potentially slowing down your sheet) before creating a pivot table.

1. From the UI menu, select Back to Main Page.

2. Select Pivot Data. You will see a layout that is very similar to the Tabular Data mode that you have seen before.

3. Model: Select the model that you want to build a pivot table from.

4. Row: Click on Select row here, you can then choose from the dropdown menu the field whose attributes you want as the rows of the pivot table. You can repeat this step to have more than one field selected.

5. Column: Similarly you can select the field whose attributes you want as the columns of the pivot table.

6. Value: Here you can select what value you want to aggregate (typically a metric such as the number of customers or the total transaction value) and how you want to aggregate (e.g. count, sum, etc.).

7. Filter and Ordering Item: These two sections work in the same way as they do in Tabular Data mode.

Currently Spreadic only supports pivot tables with one or more row field, a single column field and exactly one value field.