Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
for example :
sum({$<paygroup]=>} [value])
I would need to do that for each Expresion in the object. I'm wondering if there's something more straightforward.