My request is not directly related to a problem, however, I got frustrated when trying to use the pivot table columns as filters in other tabs of my dashboard.
I am developing a report that provides a grouped view of my expenses. These expenses serve as a sort of classification for my charts of accounts, so within an expense, I can have N charts of accounts.
My pivot table is as follows: Year ---> Expenses ---> Charts of accounts.

I would like the pivot table to have an option like in the table, which allows me to choose whether a certain row, from a certain column, serves as a filter.
In the table, I can manipulate the click behavior and say that each will correspond to a filter. My problem is in the pivot grouping, which will try to use the same value in each filter that is turned on.

I would like to click on Logistics (expense) and be directed to the second screen with only the value of the expenses in the filter, click on fuel (chart of accounts) and have the value corresponding to that click placed in my filter, as happens in the table.

I tried to create more groups to have more cascades in the pivot table, but it didn't work because I don't have the same autonomy for the table.

This would be extremely important to make my dashboard more dynamic, since I often need to filter a specific plan.