Forum Discussion

chetanpatil's avatar
chetanpatil
Qrew Cadet
7 years ago

Creating monthly report?

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 

4 Replies

  • 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.
    • chetanpatil's avatar
      chetanpatil
      Qrew Cadet
      I want to add few more fields in new table and do different calculations and create graphs but I need the data monthly.
    • ChuckGrigsby's avatar
      ChuckGrigsby
      Qrew Cadet
      Can you give a couple examples of the new fields you want to add? 
    • chetanpatil's avatar
      chetanpatil
      Qrew Cadet
      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