Export ODS or EXCEL, Columns dynamic

Hello dears,
See how I can export an excel or ods to make the columns dynamic.

There is the generic CSV export.

What do you mean by dynamic?

Think of years as columns, if I generate a report of a 2 consecutive years, this generates me 2 columns, 2018 and 2019, now another day I want to get a report of the last 5 years, then the columns should be 2015, 2016, 2017, 2018 and 2019.

oh take a pivot in ods

Probably what you are searching is vertical table creation in ods report.

That same, but I entered the link and can not find the solution to the previous topic.