How to create a SumOver function in QS that subjects to only chosen filters

Hey @Aravind , sorry to get back to you so late! I think I found a potential solution for you thought after to digging into this more.

Can you take a look at this example from Demo Central as well as the QS community question it stemmed from:

I know that this may require you to change your visual to a pivot table but I think this will allow you to have your filter not affect multiple fields.

Let me know if this works!