Skip to main content
Question

Report: Month over Month - Many to Many

  • April 15, 2017
  • 0 replies
  • 25 views

Hello. I have tables of "Invoices", "Lines"  and "Invoice-Line" to create the many to many relationship.

I need to create a report that lists some information about the Line (maybe the name and location) and the dollar amount each month's invoice. How do I do this? Example below. (I am open to other formats as necessary).

Ideally, I would be able to have multiple pieces of information from the Invoice as well, for example the Base Cost and the Total Actuals.

      This topic has been closed for replies.

      • MCFNeil
      • Quickbase Alumni
      • April 15, 2017
      Depending on how you have the information you should be able to do this already.

      Experiment with a summary report.  Particularly the grouping options.

      You might have to make sure that all those dollar values are summarized to the main invoice if they aren't already. 
      Terms & ConditionsAccessibility statement