Pivot Table Card Collapse/Expand

The documentation on the Pivot Table card shows the ability to collapse/expand rows and columns as functionatlity but I cannot figure out how to do it. Can someone point me in the right direction?

Here's the documentation I'm referencing: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Pivot_Table_-_BETA

Screenshot of the available functionality attached.

Pivot table card functionality.png

Find more posts tagged with

Cards

Table

Accepted answers

MarkSnodgrass

You need to have two fields in the Rows section and then you also need to turn on Show Subtotal Rows in the Chart Properties - Subtotal properties. It won't show unless both of those are in place.

All comments

MarkSnodgrass

You need to have two fields in the Rows section and then you also need to turn on Show Subtotal Rows in the Chart Properties - Subtotal properties. It won't show unless both of those are in place.

ccccc4

Once subtotals are added, I can see the ability to collapse rows, but not columns.

MarkSnodgrass

In the Subtotals Chart Properties, if you scroll down there is the option to Show Subtotal Columns. If you check that, you can then collapse the columns as well.

user10378

This was what I needed. Thanks Mark!