nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I sum CAD transaction values directly inside a table in Confluence?

Evelyn Sharpe

Hi everyone, I'm new to the Community 😊

I have a list of transactions (in CAD – Canadian Dollars) that I’d like to manage directly inside Confluence without having to rely on Excel or Google Sheets. Is there a way to import this data into a table and automatically calculate the total amount (and maybe other aggregations like averages) directly on the page? I’d love to keep everything inside Confluence if possible.

Cheers,
Ev

Accepted answers

Mia Tamm _Simpleasyty_

Hey @Evelyn Sharpe, welcome to the Community! 👋😊

If you’re looking to manage your CAD transactions directly inside Confluence without jumping in and out of Excel or Google Sheets, you might want to try the Simple Table with Body macro (from our app Simple Tables for Confluence).

With it you can:

Add your table from Confluence
Display your CAD values in a column
And automatically calculate the total sum (plus average, min, max, count…) using built-in footer aggregations — all without leaving the page

Screenshot 2025-08-17 at 11.14.40.png

I actually recorded a quick Loom showing this exact setup — happy to post it here if that would be helpful for you? 😊

— Mia Tamm from Simpleasyty

All comments

Tomislav Tobijas

Hey @Evelyn Sharpe ,

Firstly—welcome to the Community! 👋

Regarding the question > while Confluence native tables do not support aggregations, you could maybe use Confluence Databases, which is also native Confluence functionality (a bit different than a page itself).

Anyway, databases support sums and averages for number columns (+ number columns can be set as currencies, although the Canadian Dollar is not yet supported).

Additionally, once you create a database, you could embed the view in the Confluence page to get a table-like representation.

Here's a short lesson in Atlassian Learning to get quickly onboarded with databases: Create databases in Confluence

Cheers,
Tobi

Mia Tamm _Simpleasyty_

Hey @Evelyn Sharpe, welcome to the Community! 👋😊

With it you can:

Add your table from Confluence
Display your CAD values in a column
And automatically calculate the total sum (plus average, min, max, count…) using built-in footer aggregations — all without leaving the page

Screenshot 2025-08-17 at 11.14.40.png

I actually recorded a quick Loom showing this exact setup — happy to post it here if that would be helpful for you? 😊

— Mia Tamm from Simpleasyty

Evelyn Sharpe

Thanks so much @Tomislav Tobijas really appreciate the warm welcome and the detailed suggestion! 🙏

Databases definitely look powerful, but I was hoping to keep things a bit more lightweight (ideally just a simple table directly on a Confluence page, without having to create a database object first).

My goal is to import a list of CAD entries, display them in a table on the page itself and have the sum of the Amount column calculated automatically right there — a bit like how you’d use =SUM() in Excel. Thanks again!

Evelyn Sharpe

Thanks so much, @Mia Tamm _Simpleasyty_ this is exactly what I was hoping to achieve!

Being able to stay on a regular Confluence page and still get automatic totals is ideal for how we work. Also, thank you for taking the time to record and share the Loom. That example makes everything much clearer and is incredibly helpful. Really appreciate it!

Thanks again, this looks very promising!

Tomislav Tobijas

Got it. Thanks for the additional info @Evelyn Sharpe !

Yeah—for that, you'd probably need to use some Marketplace app as, natively, this is not supported. 😕

One additional solution/workaround could be embedding Excel directly to Confluence if you have those stored somewhere on the cloud > see example here (steps are the same for Excel or Google files).

Anwesha Pan

Hi @Evelyn Sharpe

Welcome to the community! ✨

To answer your question --> If you would like to use already installed app in Confluence

You can use /table spreadsheet macro to upload a file and display its content as an excel on that same page, which you can edit & save on the page itself --> Table spreadsheet

Example

Table spreadsheet.png

I hope this helps. 😊

Thanks,
Anwesha

Stiltsoft support

Hi @Evelyn Sharpe ,

We can also suggest trying the app that we develop - Table Filter, Charts & Spreadsheets for Confluence.

You'll be able to set a total row (sum, min, max, average, etc.) using the Table Filter macro: https://docs.stiltsoft.com/tfac/cloud/calculations-in-tables-42239860.html#Calculationsintables-OutputtheTotalrow

Screenshot 2025-08-21 at 16.07.31.png

And if you prefer Excel-style while working with your data, you may take the Table Spreadsheet macro that is also provided with the app.

Maybe you want to see the case live? Please book a call with us, we'll be happy to assist.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

table

table-filter

table-filter-and-charts

table-spreadsheet

table-filter-charts-spreadsheets