How to calculate margins and totals from an Excel file in Confluence?

[Camille Moreau]

Hi community of Confluence, in our team, we use an Excel file to track sales. This Excel is linked to our Approvals for Confluence, so we also need the information to be visible in Confluence for the team to access it without leaving the wiki.

The file includes columns such as:

• Product
• Unit cost
• Sale price
• Units sold

What we need is:

1. Import the Excel into Confluence.
2. Add a calculated column to get the profit margin per unit (Sale price – Unit cost).
3. Show in the table footer the total profit for all products ((Sale price – Unit cost) × Units sold).

Is there an easy way to do this directly in Confluence, without having to pre-calculate these values in Excel before importing it?

Thanks