Hi
I'm building an app to manage sales of products in countries(which are part of continents) .
There is a need to present a summary table.
In Excel, it would be a pivot table where in rows I would have the products, and in columns it wild have 2 dimensions: the continent, and then the country. In values, I need to show the number of products sold.
The continent shouldn't be repeating, but rather showing only on top of the first country of that continent. number of columns and rows should be dynamic based on the existing data.
Example:
Is it possible to build the same in Apex?
What components should be used? And how to obtain the 2 levels in the columns?