Pivot

Pivot is a multidimensional array of data:

Let us take a “Pivot” that shows volume of sales and profit by product category in each country as an example. For this we choose “Pivot” in the toolbar, in the value field we will have “Reseller Sales Amount” and “Reseller Gross Profit” measures, on the rows of the “Country” and “Category” hierarchy. The pivot will look the following: