Using filtered questions on dashboard as basis for 3rd question

Get Help
1

Hi,

I am creating a dashboard with 3 questions.
Question A (basic table) (ex. Store Name, Revenue($), Year , Month) Then I have it summarizing revenue grouped by Store Name.
Question B (basic table) (ex. Store Name, Cost($), Year, Month) Then I have it summarizing cost grouped by Store Name.
Question C - which displays Question A joined with Question B (A.StoreName = B.StoreName), and displays a custom column with Profit = Revenue - Cost.

I am able to add a dashboard filter for Year and Month that can filter the data retrieved for Questions A and B. However, I want these filters to propagate into Question C. For example I want to be able to select Year = 2024 and have the Profits in Question C reflect only the year 2024.
Even when I go to the question editore for Question C, there is no way to filter the Year/Month from A and B.

Is there a way to achieve what I want?

2

is the profit a custom column I would guess? if so, I'm pretty sure you're hitting Custom Column after aggregation causes dashboard filtering to be very limited · Issue #19744 · metabase/metabase · GitHub