Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there any way to autosum like in Excel 'Status' Macros?

mani.s September 7, 2021

So I have a page where I have 3 'Status' but over 40 lines in which they are being used to update the status.

At the moment IStatus.PNG have to manually count each one and i was wondering if there is a way to get Confluence to AUTOSUM like in Excel

2 answers

3 votes
Alexis Robert
Community Champion
September 7, 2021

Hi @mani.s , 

 

the easiest way is to get an addon for this, like Table Filters and Charts. There is a filter bundled that can be used to sum number.

 

Let me know if this helps,

 

--Alexis

mani.s September 7, 2021

Thanks, unfortunately it would be quicker for me to manually add the info, than try and get an addon 

2 votes
Katerina Kovriga _Stiltsoft_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 7, 2021

Hi @mani.s ,

We can suggest trying our app - Table Filter and Charts for Confluence (available for Cloud/Server/Data Center).

Its Pivot Table macro works similar to Excel and will be perfect for your task:

Tue 1-1.png

Tue 1-2.png

Our app supports all the dynamically changing table macros such as Page Properties Report, Jira Issues, Content Report Table, etc., so you'll be able to filter, aggregate and visualize them as well as your regular manually created Confluence tables.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events