A specific use case for dynamic columns in combination with dynamic rows is to include so-called dependent rows. In such a case, Grid can determine a separate list of rows per column value. Our formula in the cells will look just like it did earlier, but RowProperty(label) results will differ for the same row in each column.
Let’s take a look at a Query with Reasons for Purchase for all makes.
And try to replicate it in Grid but with the top reasons displayed separately for each column.
To start, our dynamic column should retrieve all makes.
Switching dependent rows to “On” for this scenario is important.
Note also that below the two first rows, we have two separate columns in which we have a reason and its score. The first two rows have their cells merged. In the first row, we use “Merge cells inside dynamic row,” and in the second row, only regular “Merge cells” are used.
Our dynamic row has to retrieve all reasons, sorted additionally by value, but instead of specifying a particular Make or Sample total that should be the base for our newly created Table, we refer to ColProperty.
For the specific cells we can define any expression we need, in our scenario it is sufficient to use RowProperty(@label) and RowProperty(@value).
We can now take a look at what we managed to achieve - even though the original Query did not include any sorting nor top X calculations. We used it to prepare a Grid that has Reasons for purchase displayed separately and sorted for each of our makes.
