Forum Discussion

cocomy's avatar
cocomy
Icon for Resolver I rankResolver I
8 years ago
Solved

Monthly total by branch

Hi All,   I am trying to calculate monthly sales by branch from actual sales table. (if no sales, no data)   Date                          Branch           Sales        Items 1 Jan 2018         ...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi cocomy,

     

    Are you sure about your relationships?

     

    I made a mockup model with your setup and go the correct result make for each month:

     

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi cocomy,

 

Are you sure about your relationships?

 

I made a mockup model with your setup and go the correct result make for each month:

 

 

Regards,

MFelix

cocomy's avatar
cocomy
Icon for Resolver I rankResolver I
8 years ago

MFelix,

 

Thank you very much again. Relationship was incorrect so I got the same number for all apparently.!

 

All the best,

cocomy