Forum Discussion

M4R10's avatar
M4R10
Frequent Visitor
8 years ago

Same items sales

I am looking for a way to build a filter that allows me to consider the sales for the same list of items through selected stores. This means, consider the list of products that have sales greater th...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

There is no file there.

M4R10's avatar
M4R10
Frequent Visitor
8 years ago

Hi Ashish_Mathur

 

The link expired after a month.

I have already uploaded again, follows the link:

https://we.tl/52vnSlrFHH

 

Hope you can advise to me.

 

regards

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    I do not understand the relatioships you have built.  Why is there no relatioship from the Date column of the tbl_price table to the date column of the tbl_calendar table?

    • M4R10's avatar
      M4R10
      Frequent Visitor
      8 years ago

      Hi Ashish_Mathur

       

      That is because the TBL_PRICES doesn't contain dates.

      Dates are contained in the VISITS table, with a secondary PERIOD table to storage only the name of periods (PERIODS could be ommited anyway)

       

      The model works as it is and all fields are connected through the current relationships.

       

      Do you estimate the current structure and model could affect to reach a solution to the original question of the topic?