Dynamically Sum Columns based on Slicer

Ashish_Mathur  It looks like you you just split the list values of lcoation into new rows. I've tried this in a couple ways. Unless I do it in my source data, I always end up with duplicated budget numerals, which means that every lead name with multiple locations would have double or triple the budget once combined. 

I see that your Approved Budget matches mine, so how did you do that? Assuming I can replicate that in my real data, I woudl then need to group by lead name for display. I can't show duplciate lead names in my tables.