How to group table by many columns in Confluence

[Nikolai Ivanov]

Hello am new in the community. I have problem with tables in Confluence. I want to see what material is not coming back to stock, because sometimes we miss refill.

Now I have big table with many rows. It is hard to read. I want to group by some columns, like material type, location, status. So I can see fast where is problem (what location missing, or what material never refill).

Is possible in Confluence? Or maybe some app in Marketplace can do this? Group by many columns in table?

Thank you

[Alessandro Cristiano - Ricksoft]

Hello @Nikolai Ivanov , welcome to Atlassian Community and thanks for sharing your challenges with us.

You might want to take a look at Excel-like Tables for Confluence, it brings up a full fledged spreadsheet application to your Confluence, allowing you to do any sort of things you would in another spreadsheet application like Microsoft Excel or Google Sheets - formulas, filters, pivot tables, graphs, you name it.

It also has a feature where you can link cells from one spreadsheet to another, so you can easily build cross-referenced tables which would help crossing references between stock and purchase orders spreadsheets for example - you can read more about it at https://docs.ricksoft-inc.com/excel-like-tables-for-confluence/link-cells-from-different-spreadsheets

Hope this helps and feel welcome to ask anything else if you need to!

Cheers,
Kind regards,
Alessandro C. | Support Manager
Ricksoft Support Team

[Jan Kuntscher - appanvil - Aura Karma Mantra]

Hi and welcome,

For grouping tables by columns, try the free app AURA Table Filter for Confluence. It lets you group by columns, filter, add charts, and more so you can spot locations or materials that never refill.

Best regards,
Jan
CEO of appanvil

[Stiltsoft support]

Hi @Nikolai Ivanov ,

You can also check the app that we develop - Table Filter, Charts & Spreadsheets for Confluence.

If you prefer working with native tables, you may take the Pivot Table macro.

If you want to work in Excel-like style, you can take the Spreadsheet from Table macro, turn your existing native table in a fully functioning spreadsheet, and create pivot tables there. And you can always use the Table Spreadsheet macro to work with spreadsheets in Confluence from scratch.

[Thiago P _Atlassian Support_]

Hey there @Nikolai Ivanov ,

Apart from the great options already mentioned here, you can check the native Confluence Databases as they have built-in sorting and filtering options.

For more details, make sure to review Create and edit databases.

Hope this helps!  =]

[Vronik]

Hi

Loot at this addon, maybe can help you

https://marketplace.atlassian.com/apps/1235329/sum-up-reports-for-confluence?hosting=cloud&tab=overview

Regards