Alternate summary fields in the same column

[Scott Strauss]

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

 

[Fons Ponsioen]

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

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.

 

[Scott Strauss]

That's about all I could come up with too. Thanks for your help with this.

Scott Strauss