I need to make a calculation with a specific group of employees in a table where there are three groups of them (PayGrp). There's a multi box in the application that allows the user to select a group for which the charts/pivot tables will do the calculation. Since the transactions are associated with the employees QV is making the calculation using those employees associated with the transactions, but I still need to calculate using the whole selected group, not only those in the transactions.
How can I specify the whole population of the selected group to do the calcs? See the data model attached.