Cashflow Impact Dashboard Formulas

I already have the raw data and a working dashboard with graphs and chart; what is missing are the formulas that let me toggle key assumptions and instantly see how they affect cashflow, graphs and charts in the dashboard. The filters I need wired in right away are Date range and Category type. When either changes, the cash-flow summary and dashboard graphs must refresh to show the resulting yearly projection.

Once the dynamic logic is in place, I also want the impact displayed three ways—graphs, tables, and charts—so the numbers and the narrative stay in sync for stakeholders who prefer different views. ( the chart and graphs already built but needs to be dynamic and sync)

the final workbook must remain self-contained in Excel. Please comment the key formulas so that future tweaks to the assumptions are easy to follow.

Deliverables:
• Updated workbook with working Date range and Category type filters tied to yearly cash-flow projections.
• Dynamic graphs, tables and charts that reflect those selections. ( already built but needs to be dynamic)
• Brief note or inline comments explaining the formula logic.

I will test by selecting different dates and categories; the output should recalculate instantly and all visuals must stay in sync.