8 Replies Latest reply on May 17, 2017 1:36 PM by Okechukwu Ossai

How do I determine cross selling when I have the sales per product and document number

Hi,

I want to find the cross selling between categories, but my data source is structured as followes:

What I want to find out above is with what categories (category 2) does A2 is making cross selling and I want to use the category 2 as a parameter from a list.

Practically I want to flag the document number where I can find A2 category present even if is not mentioned in "category 2" field for each of the lines.

for example, from above A2 is making cross sell with A1 (1 USD), A3 (3 USD), B1 (4 USD) and B2 (6 USD).

I cannot attach the data from my company but if you can help me with the presented example I would be very gratefully

Thanks,

Stefan

• 1. Re: How do I determine cross selling when I have the sales per product and document number

Category2 to Parameter

IF [category2])= 'A2' OR [cross selling flag] = 'corss selling A2' THEN  [categpry2] END

• 2. Re: How do I determine cross selling when I have the sales per product and document number

Sorry not mentioning I do not have the cross selling flag into the database and actually, this is the field that I want to build into my formula, but I do not find a solution of doing it.

• 3. Re: How do I determine cross selling when I have the sales per product and document number

what logic did you use to get cross selling flag?

• 4. Re: How do I determine cross selling when I have the sales per product and document number

into the example is made manually, but the logic has been to flag all the documents that had on them A2 category.

• 5. Re: How do I determine cross selling when I have the sales per product and document number

Without the logic, I do not see how to flag the document number where I can find A2 category present even if is not mentioned in "category 2" field for each of the lines.

How do we know that A2 is making cross-sell with A1 (1 USD), A3 (3 USD), B1 (4 USD) and B2 (6 USD)?

• 6. Re: How do I determine cross selling when I have the sales per product and document number

A2 is on the same document with products from the categories A1, A3, B1 and B2 and the sum of them is turning the cross selling.

• 7. Re: How do I determine cross selling when I have the sales per product and document number

We only have one problem: This:

IF [category2])= 'A2' OR [category 2] = 'A' THEN  [categpry2] END

This will give us everything but line 5 since Category 2 is 'B'. Can we use doc number?

• 8. Re: How do I determine cross selling when I have the sales per product and document number

Hi Stefan,

Check if this solution works for you. It looks good at my end.

1. Create calculated field [Cross Selling Flag]

{FIXED [Doc Number]: MIN(IF [Category 2] = "A2" THEN "Cross selling A2" ELSE "Not cross selling A2" END)}

Hope this helps.

Ossai