# Compare data in a matrix

The Matrix feature in Flex Modes lets you analyze two dimensions at once by turning selected entities into columns. This pivot-style view makes side-by-side comparisons easy, so you can quickly spot patterns, gaps, and opportunities across your data. For example, suppose you want to compare the performance of your sales reps side-by-side against the regions where you sell your products.

{% embed url="<https://phocassoftware.wistia.com/medias/lgphza565k>" %}
Compare data in a matrix
{% endembed %}

1. Select the first dimension you want to matrix (Sales Rep). This is the one that will be transformed into columns in the grid.&#x20;
2. Select the rows of the entities you want to matrix (top 5 performing sales reps). As with the **Focus** button, when you select rows, the **Matrix** button becomes active in the filter bar.&#x20;

   <div align="left"><figure><img src="https://3905307611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FitAvDF3MljQXV0rjHRP7%2Fuploads%2FZ5hunTzS2eEPqDpqPLZb%2FScreenshot%202025-08-13%20at%2015.20.25.png?alt=media&#x26;token=e8048d15-7aa6-41d2-8c69-9a4e0144286c" alt="" width="276"><figcaption></figcaption></figure></div>
3. Click the **Matrix** button. The other data is filtered out and the grid updates to show the selected rows, which are also transformed into columns. A matrix tag displays on the right of the filter bar.

   <div align="left"><figure><img src="https://3905307611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FitAvDF3MljQXV0rjHRP7%2Fuploads%2F3w7u13PGC5skcicvzCCE%2FMatrixmodeflexmodes1.png?alt=media&#x26;token=9d4e4837-04d4-4678-92a2-dc3258f478e8" alt="" width="563"><figcaption></figcaption></figure></div>
4. Select the second dimension you want to include in the matrix (Region). Its data displays in rows in the grid, so you can see the values against each of the other dimension's entities (sales reps columns).

   <div align="left"><figure><img src="https://content.gitbook.com/content/itAvDF3MljQXV0rjHRP7/blobs/HBGshWYs6el1yJRtERNj/image.png" alt="" width="525"><figcaption></figcaption></figure></div>

In the matrix grid, you can continue your analysis.

* Focus on specific rows to reduce the dataset in the matrix.
* Apply conditional formatting to highlight specific data.
* Pivot the matrix (switch the dimensions around). Select the rows then click the **Pivot** button. The rows are transformed into columns and vice versa.

<figure><img src="https://content.gitbook.com/content/itAvDF3MljQXV0rjHRP7/blobs/nM2gUFlgjZBC0hsYDya3/image.png" alt=""><figcaption></figcaption></figure>
