Forum Discussion

Saxon202202's avatar
Saxon202202
Icon for Helper III rankHelper III
3 years ago

Min and max based in-between two tables

Hi, I have two tables are Data and Report. In data table contain the following columns are Item, country code, sale qty. In report table contain the following columns are item and project co...
Need Help
Saxon202202's avatar
Saxon202202
Icon for Helper III rankHelper III
3 years ago

smpa01 , Thanks for your reply. No, it doesn't work.

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

Many to many is not best practice but I will leave arguing for that portion and simply going to assume that you have a business case.

 

I refrain from working with many to many but I can see that it works with an indirect relationship without a USERELATIONSHIP callback

 

 

 

 

  • Saxon10's avatar
    Saxon10
    Icon for Post Prodigy rankPost Prodigy
    3 years ago

    smpa01, Thanks for your reply. It means I need to remove the relationship in between two tables?

    Is that possible to create a unique count for country code, TOPN in order to filter the result in report table? I tried couple of function but it doesn't work for me.