You can only pivot data:
- On grid cards.
- In an Excel document.
- On cards saved from a default module view.
- When you insert card data, not images.
When you pivot, you cannot display more than three dimensions on either rows or columns. For example, you could display three dimensions on rows and three dimensions on columns.
To pivot a card's data:
- Select a cell within your Excel document.
- In the Templates tab, select a grid card.
- Select the arrow to the right of Insert as image, then select Insert card's data.
- Select Pivot
The Pivot data panel displays.
in the toolbar in the top-right. - Drag and drop the dimensions between the Context Selectors, Rows or Columns sections.
If the Column or Row section contains multiple dimensions, they're nested in the document. Dimensions at the top of a section display on the outside, and those at the bottom on the inside. - Select Confirm.
You can now insert your pivoted data.