I couldn’t find a way to do this. I have another table called [Invoices], which includes a ‘Pay Month’ column displaying text values like ‘June/2025’. What I want is to filter those values to show only unique entries, one per row, in a new table. Is that possible? If not I would have to write man…

If it was only about aggregating data, grouping would probably have been enough. But since you want to do calculations based on the aggregated data it is cleaner to have two tables as you suggested. So I just copied your data and did the following: Changed your ‘Pay month’ column from text to dat…

Is it possible to create formulaticaly a list of months (1 per row) in a table?

Pablo_DV June 25, 2025, 8:09am 2

Hi Henrique,

I guess youu want to also aggregate the amounts of the invoices to belong to the same month?

Regarding the table with the unique entries, do you want to show only the last 6 months or all of them?

Depending on the answers my answer would change a bit.

It would also be helpful if you could share a dummy doc.

Pablo

1 Like

Topic		Replies	Views
How to filter a table by a month	6	1426	December 5, 2022
Create a button to create rows with filtering	2	392	March 19, 2021
[Solved] Going crazy, not getting positive results	6	615	July 17, 2019
Create monthly totals from table with daily data	7	2989	May 22, 2019
Button to create rows for the next month	25	1622	August 24, 2021

Is it possible to create formulaticaly a list of months (1 per row) in a table?

Related topics