Re: Trying to find sales figures of certain products.

Nel post news:7B3A4F9B-DA95-49AB-846B-FD5C50CAB844@xxxxxxxxxxxxx
*Toto* ha scritto:

Thanks for your help. I am sorry, but may be I haven't raised my
question clear.
Some invoices have both product A and product B, some have only
product A or B.
I am looking for the salesamount for product A only when it is sold
together with product B (there are 15.000 lines...). Perhaps I can
extend my chart with a column with a function that return the amount
if the criteria in the function is right..? But how ??

Toto :-)

Toto skrev:

I need a formula to find how many productA(f.ex. apples) have I sold
at the same time as i have sold productB (f.ex bananas) (with
identical invoicenumber), f.ex.:
invoiceno. product kg
50 apples 1,00
50 bananas 2,00
51 apples 1,00
52 apples 1,00
53 apples 1,00
53 bananas 2,00
54 bananas 2,00
55 apples 1,00
55 bananas 2,00

Maybe you can try to use a Pivot Table. It's a very good way to summarize
informations.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


.

Relevant Pages

  • Re: quick foods
    ... fruit (berries of all kinds, melons & bananas - since I'm allergic to apples, plums and peaches) ... cottage cheese & yoghurt ... What kinds of foods do you like to keep around as quick and easy, ...
    (alt.med.fibromyalgia)
  • What is the best way to load this tree (c# & sql question)
    ... Say you have three tables apples, oranges and bananas and each table has a ... bananas) And second it won't work because I don't have a sql statement ... unions but due to the unequal amount of fields it's not working out for me. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: mysql update/replace syntax
    ... How much of each fruit do you sell each ... Fred Smith 1/1/04 Banana 3 ... You can tell how many apples and bananas have been sold, ...
    (comp.lang.php)
  • Re: Linear Logic Maybe?
    ... I have more a composition/application ... Let @ denote the application. ... In the example we had apples and bananas. ...
    (comp.lang.prolog)
  • Re: HELP! Filtering and sorting lists.
    ... Qty Prod ...
    (microsoft.public.excel.worksheet.functions)