Straight table, get sum of measure based on value in the dimension.
I have ran into a problem using qlik sense for which i need a solution. I have a straight table with a couple of dimensions and few measures. When i apply the filter and select a particular value, the data in the table shows correctly but when the filter is unchecked the data in the table becomes in correct. I want that data should be calculated based on the value in the column as the filter does it.. Attached is the screen shot for reference.