In this recipe, we will take you through the steps required to display raw data into groups. This can be useful if we want to create group sum functions. In this recipe, we will order the data into groups of counties and cities. This will then allow us to add sums for each city or country group.
To get ready for this recipe, you will have to make sure your MongoDB instance is running.
We are going to use a PDI transformation to populate the report from a previous recipe. This transformation will give us a list of orders by country, city, and product line: