Trying to find the right calulation for retail dollars

[brando1083]

hello all.

 

I am trying to find out the right way to find totals of retail dollars by specific departments or sales staff.   so in my mind i think...   Get retail if dept="A".  or Get retail if sales="debbie".   and what i would want would be a total of all retail dollars for all entries that that department or sales person equals.

 

 

make sense?

[Rick Whitelaw]

It would help to know more about your table structure and relationships. Have you checked out summaries and sub-summaries?

[comment]

what i would want would be a total of all retail dollars for all entries that that department or sales person equals.

 

Use a summary field and place it in a sub-summary part (or sub-summary parts). When your records are sorted by the field associated with the sub-summary part, the summary field will show the corresponding sub-summary value for each group of records.