Home Forums Power Pivot Does this require CONTAINS?

This topic contains 0 replies, has 1 voice, and was last updated by  Bel 1 week, 2 days ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #14378

    Bel
    Participant
    • Started: 4
    • Replies: 0
    • Total: 4

    Hi

    I have a scenario:

    Company                                        Amount

    Apple                                               5

    Orange                                            10

    Banana                                           15

    Apple, Orange, Banana              20

    Orange, Banana                           25

    I want to count sales by individual “Fruit” i.e. Apple on its own 2 and the SUM to display 25

    How can I achieve this? Any ideas will be much appreciated!

    Cheers

    Bel

     

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.