Click behavior doesn't work for Group bys in Pivot Tables

[ignacio-mb]

Describe the bug

If you have a pivot table with several summarizations and group bys, when setting up click-behavior, you won't get any variables passed through the click-behavior when clicking the group bys, but yes, the aggregations.

Probably related to the fix we pulled up for this issue: #25203

To Reproduce

1. Create a Pivot Table based on Orders. Count of rows and sum of Total Grouped by Created At: Year (binned) and Product Category. Save.
2. Add this pivot table to a dashboard
3. Set up click behavior for that Table, using any field to any field (indistinct). Save.
4. See that when you click on the Year field of the Pivot table you won't get any variable passed, but when you click on the Summarizations, you get the values configured.

testing.click.behavior.mov

Expected behavior

Logs

No response

Information about your Metabase installation

- 49.8

Severity

P2

Additional context

A couple of customers are requesting this as the expected behavior

[cdeweyx]

I think the best course of action here is to:

1. Not allow these groupby columns to be mapped to click behavior in pivot tables (this never worked, and we are letting people hit a dead end)
2. Treat this issue as a feature request, and incorporate into other pivot table improvement plans for the future