Forum Discussion

SammyNed's avatar
SammyNed
Icon for Helper I rankHelper I
5 years ago

Combination Sum

Hi  guys,   Can you please assist? I have 2 tables, Table 1 basically shows how much Customer (Column: Y-ID) spent (Column: Spend) purchasing a certain number of products( Column: Orders) under di...
SammyNed's avatar
SammyNed
Icon for Helper I rankHelper I
5 years ago

Unfortunately there's no particular algorhim, just need to know which Items make up the total spend.  Can be random, sometimes all the items add up to the total spend and sometimes only a few items add up to the table spend.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

You're out of luck here. To determine which items could constitute the whole (without any other constraints on the problem) you'd need to check all the possible combinations of items. This is not feasible and it's not the kind of problem that PBI has been created to solve.

  • SammyNed's avatar
    SammyNed
    Icon for Helper I rankHelper I
    5 years ago

    Thank you for your feedback. At least now I can stop banging my head against the wall trying to figure something out. ğŸ˜€