Creating monthly report?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have table which contains purchase orders and i want to create a new table which will have all the metrics and summary of purchases grouped by month. How can i create this new table?. How should I create relationship between new table and purchase order?
Thank you 
Photo of chetan patil

chetan patil

  • 210 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
I'm not so sure you need a new table. I think you could do this with a summary report. Filter to show orders past 30 days.
Photo of chetan patil

chetan patil

  • 210 Points 100 badge 2x thumb
I want to add few more fields in new table and do different calculations and create graphs but I need the data monthly.
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Can you give a couple examples of the new fields you want to add? 
Photo of chetan patil

chetan patil

  • 210 Points 100 badge 2x thumb
I want to create a table not the summary report. The new fields will be entered manually and used for calculation. Can you guide me how can i create new table containing data from Purchase orders table grouped by monthly. Thanks