Apportioning cashflow values across dates using a date table

[TimQ]

I've developed a report that displays project cost cash flow values across years. The data and report are here. The data is grouped by project name, phase and category, and includes start and end dates. I've developed a cash flow column within the date dimension query. It seems to work. However, I want to be able to slice or display the visual by project names, categories, phases, etc., but becuase the cash flow column lives in the the date dimension query, I cannot do it. Is there a way around this? Perhaps there's a better way to set up these calculations. 

[Greg_Deckler]

@TimQ - Is the relationship between your two tables Single or Both? Perhaps you might implement your cost as a measure? I can't be sure, I didn't download your files. Maybe if you posted some sample data as text, expected output or some screen shots.

[TimQ]

@Greg_Deckler  It appears that switching the relationship to both directions doesn't help. My hope is to display a cash flow bar chart as depicted in the orginal post, but with stacked bars using project name, phase, or category to denote the relative costs for each of those dimensions. The data looks like this:

Project Name	Phase	Start	End	Cost	Category
Project 1	Planning	1/1/2021	12/30/2022	$176,124	A
Project 1	Design	12/30/2022	12/29/2023	$717,864	A
Project 1	Construction	12/29/2023	12/26/2025	$1,262,806	A
Project 2	Planning	7/1/2021	6/29/2023	$181,634	B
Project 2	Design	6/29/2023	6/27/2024	$856,281	B
Project 2	Construction	6/27/2024	6/25/2026	$6,711,193	B
Project 3	Planning	6/6/2030	6/5/2031	$237,761	C
Project 3	Design	6/5/2031	6/3/2032	$776,787	C
Project 3	Construction	6/5/2031	6/1/2034	$1,950,365	C
Project 4	Planning	1/1/2021	12/31/2021	$146,569	D
Project 4	Design	12/31/2021	12/29/2023	$947,885	D
Project 4	Construction	12/29/2023	6/26/2026	$1,584,169	D