Skip to main content

Pivot table

Add a pivot table to a Yeeflow page and summarize data list records by row, column, and value.

A pivot table groups records from a data list and calculates a summary for each group. For example, use quarters and regions as rows, product categories as columns, and sales and cost totals as values to compare performance.


Add a pivot table

In the page designer, find Pivot table in the controls panel and drag it into a section or container.


Select a data source

  1. Select the control and open Content → Data Source.

  2. In Application, choose the application that contains the source. The current application is selected by default.

  3. In List, select your data list. To summarize a subset, open Data Filters and set the conditions. For example, limit the sales records to one reporting year.


Rows, columns, and values

Use the Rows, Columns, and Values blocks in the Content tab. Row and column fields define the groups. Value fields define the calculation for each intersection.

Rows

Click Add Row and expand the entry to select a list field. Add a second row field to group records within the first field. For the sales example, add Date and choose Quarter for its dimension, then add Region. Date fields also support grouping by day, week, month, or year. You can adjust each row field’s width, text color, and background color.

Columns

Click Add Column and select a list field. Choose Product Category in the sales example so each category gets its own set of values. You can add more column fields and adjust their widths in pixels or percentages.

Values

Click Add Value, select a list field, and choose its Dimension. Use Count to count records, Count distinct to count unique values, or Sum, Avg, Max, or Min to summarize a numeric field.

For the sales example, set both Sales and Cost to Sum. Enable Show Total to include subtotals and a grand total. When using Sum or Avg, use Show value as if you want a percentage display.

In the example below, furniture sales for Central, East, and West in Q1 add up to $39,998.68. Preview your own table and compare one subtotal against the matching records in your source list.

Furniture sales and cost in Q1, grouped by Central, East, and West. The sales subtotal is $39,998.68.


Appearance settings

In Content → Appearance, turn on Sorting table if readers need to sort by a column. Preview the page and select a sortable column header to check the result.


Style the pivot table

Use the Style tab to set the table layout and distinguish the headers, subtotals, and grand total.

General

Set the table width and alignment, then choose a column width mode. Fixed uses the widths you assigned to individual columns. Auto scales them to fit the table width. Use the border, corner radius, and shadow options to style the outside of the table. You can also hide the border around the body.

Table header

Set the header cells’ padding, borders, horizontal and vertical alignment, typography, and colors. You can use a solid or gradient background.

Table content

Set the padding, borders, and alignment for the body cells. Use Content Style and Subtotals Style to distinguish detail rows from subtotal rows. Each offers typography and normal and hover colors.

Grand total

Set the padding, borders, alignment, typography, and colors for the overall total row. Turn on Show Total in Content → Values to see it in the table.


Advanced settings

Use the Advanced tab for applicable control layout and display settings, such as margin, padding, or visibility. Advanced Settings Tab


​
​

Did this answer your question?