Alternate summary fields in the same column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a report that has a column that calculates commissions as a percentage of total sales depending on the group the employees are associated with. If the percentage is for Group A, the percentage should use Total Sales (on the report). If the percentage is for Group B the calculation must use the Total Adjusted Sales for Group B only

Sales and Adjusted Sales are included as detail line items for all employees

Any ideas would be appreciated

Thank

Scott Strauss
 
The way I would handle this would be to create a totals
query grouped by your group, than you cna use these totals
linked to your table to calculate the percentiles.
Without further specific data I don't think I can give you
a more specific idea.
Hope this helps.
Fons
-----Original Message-----
I am working on a report that has a column that
Click to expand...
calculates commissions as a percentage of total sales
depending on the group the employees are associated with.
If the percentage is for Group A, the percentage should
use Total Sales (on the report). If the percentage is for
Group B the calculation must use the Total Adjusted Sales
for Group B only.
 
Back
Top