Summaries in Reports
Hi,
This has probably been asked numerous times but I just can't find the answer but I can't believe it isn't possible.
I am making a simple equipment inventory with servicing data within it. The services are carried out on a 1,2 or 3 year rolling cycle, so I want to be able to print off a report at the start of each year to show me all of the services that are due to be carried out.
I would like to include a very simple summary of that data in the report such as the total number of services due, and the total cost associated. But there doesn't seem to be a straightforward way of doing it.
Any help would be greatly appreciated
Chris
Answers
-
You would want to create a new sheet (or find some space on the current data sheet) and use formulas to pull those metrics.
From the sound of things, those formulas would most likely end up being relatively straight forward.
But you cannot reference reports in formulas to pull metrics.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives