Sum of Values with different filters and multiple data source blended together

Hi All,

I have two values generated by applying different filters to both the values. Both the values are generated from multiple data sources blended together. Is there a way to sum those values ignoring filters?

I can't have duplicate data source since there are multiple values and all with different filters. I have also attached a sample copy and screenshots for reference.

                                                                                           Sheet 1                                                              Sheet 2

I need sum of both the values: 6.286 + 40.86

I have also attached sample copy of my work that I am working with.

I'd highly appreciate your assistance. Teju Deep Pamarty Norbert Maijoor

Thanks.