Grouping Rows by Month

Hannes_1lmbh8

I have a table with different Orders, every Order has a date and a price.

I want to create a chart where i can see how much money ive spend in each Month.

The best layout would be:

Katerina Rudkovskaya _Stiltsoft_

Hi @Hannes,

As for now, you can’t perform calculations and aggregation in Confluence natively, you’ll need some additional apps for this purpose.

For example, we develop the Table Filter and Charts for Confluence app.

Its Pivot Table macro and then Chart from Table macro will help you to group and visualize your data if you prefer to work with native Confluence tables.

Or you can use the Table Spreadsheet macro if you want to have all the Excel-like features.