Disable a Pivot Table?

Hello! It seems that some of my Questions in metabase allow me to disable the Pivot Table option, while others do not. I am trying to disable the Pivot Table option so that I can display the raw data as a module within a dashboard.

On the top is an example of a Question that does allow me to disable Pivot Table, and on the bottom is an example of a Question that does not allow me to disable Pivot Table:

Is there something I am missing here? Any insight much appreciated -A

1 Like

Hi @andrew
How many columns are you returning in the lower question? Make sure it’s 3 columns.
There’s an issue open about problems with enabling/disabling pivot:
https://github.com/metabase/metabase/issues/9874 - upvote by clicking :+1: on the first post

1 Like

Thank you!

The lower question returns 4 columns. When I change it to return 3 columns, the Pivot Table toggle does indeed appear.

Upvoting now :slight_smile: