Need a calculation with set analysis that doesn't take into account some (selected) fields
I have a complex task and a trouble with it. Simplifying the data let's assume I have a table of companies of several types. Each company has a personal manager. I also have a table of powers of attorney given by the companies to some representatives. There are several types of POAs. Not all the companies have given a POA. I need to construct a calculation that counts for earch manager a number of total companies (TC) and a number of those, that have given a POA (GP). When I click and choose a type of POA the GP values should change, but the TC values should remain. But when I click and choose the type of company both values should change respectively. So I need the calculation that ignores some fields selection, but takes into account the others. Thanks in advance!