Simple Table: Calculating Department Totals and Employee Compensation

Ananya Sharma_pluhaz

Hi community,

In our quarterly performance report, we maintain a table with columns for Department, Employee, Hours Worked, Hourly Rate, and Bonus (%).

I’d like to automatically calculate:

• The Total Compensation for each employee (Hours Worked * Hourly Rate + Bonus),

• The Average Hourly Rate per department,

• And the Total Compensation per Department.

Finally, I’d like to group the table by Department so that each department shows its subtotal and average values at the bottom of the group.

Is this possible directly inside Simple Table without exporting the data to Excel?

Mia Tamm _Simpleasyty_

Hi @Ananya Sharma 

Thank you so much for using Simple Table and for your detailed question. It’s a great use case!

Here’s an example dataset you can try (you can copy-paste it into Confluence as a CSV and import it through the Import → CSV option):

 

<span>Department,Employee,Hours Worked,Hourly Rate,Bonus (%)
Sales,Naoko Tanaka,160,35,5
Sales,Kenji Mori,150,32,10
Sales,Ayumi Kato,170,34,0
Engineering,Taro Suzuki,165,45,8
Engineering,Yuki Watanabe,155,42,5
Engineering,Hiroshi Ito,160,44,0
Marketing,Mai Kobayashi,150,30,5
Marketing,Kenta Sato,155,28,0
Marketing,Erika Nishimura,160,31,8
</span>

 Once imported:

1. Add a Calculated Column named Total Compensation with the formula:

   <span>= [Hours Worked] * [Hourly Rate] * (1 + [Bonus (%)] / 100) </span>

2. Go to Display → Grouping and group by Department.

3. In Columns → Total Compensation, enable a footer function → SUM.
   (You can also use AVG on the Hourly Rate column to show average rates per department.)

This will give you subtotals and averages directly inside Simple Table — no Excel export needed.

If you need any assistance setting this up or want to share your table privately, feel free to open a ticket via the Support tab on our Marketplace listing. Our team will be happy to help!

Best,

— Mia Tamm