Dynamic CROSSTAB columns with newly added column

[wonka1234]

Hi,

I need to add columns to my crosstab dynamically.. I feel like i always have to update it based on my inputs i load.

I would like to add the newly added columns without having to change them here..  I want to leave "Name" and "value" unchecked.

Ie if I load columns 202203, 202204 and so on it should automatially be picked up by the cross tab and not need alteryx.

any help would be appreciated.

[wonka1234]

@Felipe_Ribeir0 

 i think previous way was better as it selects everythin but name and value. I h ave more then just 202202 and 202203 that needs to be groups by.. but still getting the error when i include everything but name and value.