Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
wgonzalez
Partner - Creator
Partner - Creator

Set Analysis: selection of specific group

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.

2 Replies
giakoum
Partner - Master II
Partner - Master II

for example :

sum({$<paygroup]=>} [value])

wgonzalez
Partner - Creator
Partner - Creator
Author

I would need to do that for each Expresion in the object.  I'm wondering if there's something more straightforward.