You can create a cost report to show the total sums from your Catalogue.
Head to Reports
2. Create a new statistics report
3. In the Report Settings tab, configure the Report Group to Cost Centre and the report Table to Cost Centre
4. In the Conditions tab, configure the filter to target the specific group you'd like to view the total cost for.
5. In the Statistic tab, select the same group in the Statistics On field that you chose in the Conditions tab.
Because this report is looking for the total cost of items, set the Statistics Fields to Cost | Sum
6. In the Results Data tab, you can select the data you want displayed in your report by selecting the downward arrow next to each heading.
For the sake of this report, select Sublocation & Sum of Cost.
7. Save your changes
8. Your report is now ready to generate.
Comments
0 comments
Please sign in to leave a comment.