is it possible i want to use table plus macro and use the function inside sum its sum my row. Now i

[Amna Shahbaz]

is it possible i want to use table plus macro and use the function inside sum its sum my row. Now i use filter table macro on this is it possible can i filter my table and just hsow the sum of select filter data in column

[Ravi Varma · Accepted solution]

Hi @Amna Shahbaz ,

Yes, it is possible. Please find the screenshots as below

Confluence table containing 5 rows with data. Using table-plus macro, we can do auto total (Refer below image)

Now, we can filter the table, using column Name (filter by Ravi), and we see two records now with the auto total functionality working based on the filtered data

Hope this helps.

Let me know, if you need the configuration part as well.

Alternately, you can reach out to our support by creating a ticket here - https://bobswift.atlassian.net/servicedesk/customer/portal/1

Regards,

Ravi Varma

[Amna Shahbaz]

yes i need configuration also can u plz tell me step by step how u did this

[Amna Shahbaz]

Now, we can filter the table, using column Name (filter by Ravi), and we see two records now with the auto total functionality working based on the filtered data. How u set filter column by column

[Ravi Varma]

You can find the configuration for the numbered columns that need auto totalling, in the above screenshot.

In fact, you can check other available functions, Average, Min and Max as well.

For further details, refer the documentation page - https://bobswift.atlassian.net/wiki/spaces/TBL/pages/838565914/Table+Plus+macro+-+8.x

[Katerina Kovriga _Stiltsoft_]

Hi @Amna Shahbaz ,

If we are talking about the Table Filter macro, then it's our Table Filter and Charts for Confluence app.

You can sum rows (output the total column) using the Table Filter macro - please check this part of our documentation. All the numeric cells will be summed up.

And if you want to sum up only specific cells, you may use the Table Transformer macro.