Total -Sales: sum(max({Sales}, [{Region}, date])) . I want to create one more calculated field that uses the total of (Total-Sales) as a denominator for another KPI. Further this denominator should change dynamically , like if i select two countries the value should show total of (Total-Sales) for that two countries .
Do you mean that you have a Country field in addition to your Region field? Do you want both your numerator and denominator to change? How do you want your numerator to change when you select a country?
Sorry it should be region, to put it simple I have an already aggregated function and the values from it should be going into another sumover calculated field but I get an error stating cant do sumover of aggregated function