I have a sheet that list vendors, end customers, and fiscal weeks, and PO's, and a q for that vendor
I am trying to put on a dashboard the number of vendor PO's that are due that week, as well as the quantities that are due that week. I currently have a report that will extract the distinct list of vendors but I am trying to get the numbers of PO's due by week as well as the actual quantity by vendor due that week.
Answers
-
How many sheets are involved? Can you use some =COUNTIFS() functions in the Summary panes and use Summary Reports to pull the data through to the dashboards? Then you can use Chart widgets on the Summary reports to show as charts?
Or could you set up a grid sheet with =COUNTIFS() functions to pull the stats into one place?
Within the report, you can use Group and Summarize tabs to count per group then you can put a shortcut to the report on the dashboard?
Would any of these help?
Kind regards
Debbie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!