Want to add values in columns in confluence

[shetty]

We want sum of all values in columns in confluence

is it possible to achieve ? Any plugin suggestion

in the last column(still need to add) the sum of all will appear

[Dominic Lagger · Accepted solution]

We use Confluence Table Filter and Charts. 

This does not sum up the table cell values. But you have the opportunity to create a pivot table and sum up with this. Also this is a nice plugin for displaying charts createt out of the table. 

The question was asked before in this thread with multiple plugin suggestions:

https://community.atlassian.com/t5/Confluence-questions/Is-it-possible-to-perform-sum-calculation-in-a-confluence-table/qaq-p/189923

[Jeremy Wood]

The quick answer is NO. You cannot add sums to a provided table without getting add-ons from the Market Place.

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hi @shetty

Table Filter macro has an option to output total column / row.

[Dominic Lagger]

Yeah thanks! I didn't know that, so was my answer :-) 

[shetty]

Thanks i got total of columns.

i have one more doubt i.e.,can i use multiexcerpt plugin to get the total column to be displyed in other page as i see no option for column to edit

[Andrey Khaneev _StiltSoft_]

It is possible to display the whole table with totals on another page only in the current version of Table Filter and Charts app. But there will appear a new Table Transformer macro that will allow to do this in the upcoming version 5.0. I'll post here later how to do this.

[shetty]

we are using Jira cloud

[Andrey Khaneev _StiltSoft_]

It will be available in Cloud version as well.

[Chiranjeevi]

Apply Formulas(+,-,/) to different columns values to get another another column in confluence. Can some one help on this without any plugin. 

[Scott Paden]

In general every team member on my team and our project managers are frustrated by the lack of spreadsheet like behavior in Confluence tables. One of the items I keep hearing about is project managers (PMs) and managers in general would like to track things in a spreadsheet.  They like jira but feel the need to have their own spreadsheet as well.  This is especially necessary as some managers of managers require such spreadsheets. 

I've endeavored to create some confluence tables that include jira items and yet allow the PMs to track other items.  However, tables in confluence are still very focused on showing static items, items from other pages, or data from jira; these tables are not good and combining table data and table calculations (other than column or row totals).   

Is there an ability to mix jira macros and formulas in Confluence tables that act more like spreadsheets?  Consider the table line below: 

I'm asking for a story like this:

As A: Project Manager

I Want: A Confluence table that combines my calculations and status of Jira issues (i.e a Confluence Spreadsheet).

So That: I can save time and reduce complexity by doing my own calculations in a single spot rather than using a mix Atlassian tools, spreadsheet tools..

 --Scott

[Andrey Khaneev _StiltSoft_]

Hi Scott,

You can wrap this table with the Tabe Transformer macro to add calculated columns. The SQL query will be similar to this one:

SELECT *, T1.'Column C' * T1.'Column D' * T1.'Column E' AS 'My result' FROM T1

where 'Column C / D / E' is the actual column name in your table.

[Ollie Guan]

Hi @shetty ,

You can try the following plugins and hope to help you.

https://marketplace.atlassian.com/apps/1212486/spreadsheets-for-confluence?hosting=cloud&tab=overview