Excel Report, Chance the name of headers

Hello.

I´m working on a Report in which I have to sum values per month, something like this.

But what I need is the header to be like 2021_3, 2021_4 and so on. Considering that is a monthly report and will always be a new month in the Report.

Thank you in advance.

Workflow

Datasets

Reporting

Help

Accepted answers

@neromerob Another way of doing this with the replace function

DynamicRename_16_05.yxmd

Muchas gracias por la solución.

All comments

@neromerob how does this look? It creates the necessary header from the old header itself so will always be dynamic. If it's not always 'CountWithNulls_' at the start then let me know and I can edit the formula.

EDIT: Have just made it dynamic anyway, assuming that it's always <letters>_ at the start.

Dynamic rename.yxmd

@neromerob Another way of doing this with the replace function

DynamicRename_16_05.yxmd

Muchas gracias por la solución.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703