Help Creating New Column From Summing Another Column
What I am trying to do seems pretty straighforward, but due to my lack of knowledge/experience, I am having a hard time getting it.
I have card that displays the total contract value of of projects assigned to a particular project manager/employee for a given time period. My goal is to create a new column that displays what percentage of the total current contract amount for the whole company each project manager/employee is currently assgined. The issue lies in the fact that I currently do not have a column/measure summing up all current projects by their contract values. So essentially how can I sum the entirety of a column for a given time period in order to use that value for other equations?
My card looks something like this....
|Project Manager||# of Jobs||Original Contract Amount||Current Contract Amount|
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 53 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 902 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部