SOOO many knowledge-base platforms have tables that do calculations as a free functionality. I do not know why Confluence has not done this yet.
It's time!
Although Confluence doesn't off that as a built-in feature, there are a few third party apps to fill the gap:
https://marketplace.atlassian.com/search?hosting=cloud&product=confluence&query=spreadsheet
Some of these are very popular (high installation count), which suggest that they probably do a pretty good job.
Hi @Ishaan Dev,
We can also suggest our app that is Table Filter and Charts for Confluence.
You may check its Table Spreadsheet macro and/or Pivot Table and Table Transformer macros if you prefer to use formulas in native Confluence tables.
We’ll be also happy to arrange a live demo for you and your team – please book a suitable time slot here.