Creating monthly report?

Question

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

chuckgrigsby · Answer

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 · Answer

I want to add few more fields in new table and do different calculations and create graphs but I need the data monthly.

chuckgrigsby · Answer

Can you give a couple examples of the new fields you want to add?&nbsp;

chetanpatil · Answer

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

Forum Discussion

Creating monthly report?

Related Content

Trying to create a report with an ask users filter, but with a multiselect

AI Smart Builder for Creating Apps and Streamlining Pipelines

Report Formulas

create pipeline to create new records based on current record

Restful API Report digesting JSON