Template design - Grouping dynamic data and creating subtotals

Introduction

EDS Publisher allows the creation of tables using dynamic and static data to which we can apply formatting for better readability, functions can be used to sort and group the data.

This article aims to provide instructions on how to use the "Group by" feature to show the information in a more concise manner.

How to

We will create a dynamic table that provides information about the CDs in a collection, grouped by the company which produced them.

  • Create a table with 2 rows and columns;
  • On the first row we will enter the column names; In this case, the CD Company, and the CD Details;
  • Right click on the second row and from Convert To select Repeating Row to convert it to a repeating row;

  • Drag and drop the Company and Title fields from the Data Source in each cell in the second row;
  • Group the data:
    • Right click on the second row
    • From the Grouping menu, select Group by… to group the data by the company
    • From the Group by panel, click the Select button below the "Group By" text and choose the grouping element (in our case, the Company)

    • Click Insert and Save, this will add an empty row above the repeating row;

  • In the empty row drag the Company field in both cells;
  • Double click the Company field in the second cell, click Create Expression from the Edit Field panel;
  • In the xPath textbox add the xPath expression that will count the number of songs for each company and click Save;
    In this case, it should be "count(/CATALOG/CD[COMPANY/text() = current()/COMPANY/text()])"

  • Click the Company field again and from the Ribbon navigate to the Dynamic tab and in the Label textbox change COMPANY to CD Details;

The output for our table will be the below:

 

Have more questions? Submit a request

Comments

Powered by Zendesk