Showing results for 
Search instead for 
Did you mean: 
travishankins Frequent Visitor
Frequent Visitor

Sum all rows based on column



I have a table that contains information such as employee, department, start date, etc.   I have a report that we need to calculate sales based on how many employees are in a department but can't figure out how to sum the number of rows for each department.  


I am sure it's something simple and would appreciate some help! 

Super User
Super User

Re: Sum all rows based on column

What does your data look like? Please see this post regarding How to Get Your Question Answered Quickly:

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Community Support Team

Re: Sum all rows based on column



You may try using SUMMARIZE Function to add a calculated table first.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.