Simple Table: Calculating Department Totals and Employee Compensation

[Ananya Sharma]

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_ · Accepted solution]

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):

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

 Once imported:

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

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

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 

[Tomislav Tobijas]

Hi @Ananya Sharma ,

I haven't used this app, but I believe @Mia Tamm _Simpleasyty_ works for the vendor and could potentially help out with this.

Additionally, on the Marketplace app listing, there's a Support tab where you can find contact details to reach out to the vendor's support team directly. I'd say this is the recommended way to ask for help when it comes to third-party apps such as this one, as support teams are usually quite responsive and are willing to help.

Cheers,
Tobi

[Mia Tamm _Simpleasyty_]

Hi @Tomislav Tobijas,

Thank you so much for tagging me and for taking the time to include this post! 🙏
I’ll be happy to assist Ananya directly and provide all the details she needs.

Really appreciate your help and support as always!

— Mia Tamm