Export ODS or EXCEL, Columns dynamic

[jerico (César Enrique Gago Egocheaga)]

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

[ced (Cédric Krier)]

@jerico

how I can export an excel or ods

There is the generic CSV export.

@jerico

to make the columns dynamic

What do you mean by dynamic?

[jerico (César Enrique Gago Egocheaga)]

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.

[jerico (César Enrique Gago Egocheaga)]

oh take a pivot in ods

[pokoli (Sergi Almacellas Abellana)]

@jerico

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.

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

[jerico (César Enrique Gago Egocheaga)]

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