Quote:
Originally Posted by Lisa274
Using your (very helpful) Tutorial as an example - I would like to explain more clearly what I am after:
Using your City and State example - if there were also multiple Managers (Mgr) per City and you wanted a sort like:
per State NSW
per City Sydney
per Mgr <tab> Representative <tab> Sales Mgr Jones Brown $5,300
Driver $8,700
Mgr Smith Gadzic $7,400
Williams $700
My question is - Would THIS scenario use 2 or 3 keys?
|
That would require three keys.
Quote:
In my "Would Like" example I would like it sorted by:
Employee Name
Benefit name with the price per pay period and the Benefit Amount *
Dependents for that Benefit
|
That still only requires two keys. See attached (Note: you'll need to change the 'PeriodicPayment' and 'BenefitAmount' mergefield names to match whatever you actually use.