Invoice calculation question

[Spac3man]

Hello,
I have a DB with tables as follows:

Customers -< Orders -< Order Line Items >- Products
v
|
Sales Campaign


Products are sold to customers based on a Sales Campaign. The Sales Campaign number is assigned to each Order. Product prices differ between Sales Campaigns.

I am trying to see a TOTAL of each product ordered based on any given Sales Campaign and I can't seem to figure it out. Any help is appreciated

 

[detourdog]

Every sale will need to record the sales campaign key field.
Create a summery field to total all sales.

The create a sub summery using the sales campaign key field.

Then create a report using sub-summery parts to total all sales broken out by sales campaign field.

I know that is a sparse explanation but we were given a sparse question.

Ben

 

[JeanW]

If you have a relationship between the products and your Sales campaign, use this to make a foundCount on each product.

This calc will give you the total of a product based on each campaign.

 

[detourdog]

JeanW is it true that your solution would need all items to have the same price in a campaign?

 

[JeanW]

The OP wants to know:
'TOTAL of each product ordered'

not the price.

You can use other functions to capture the total price through the relationship.