topic Re: Automatic column selection and use in formula in General Discussions https://community.alteryx.com/t5/General-Discussions/Automatic-column-selection-and-use-in-formula/m-p/1179486#M9749 <P>Try using a sample tool to take only the latest data from the transpose.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/320281iA3CED097E1A97936/image-size/medium?v=v2&amp;px=400" role="button" title="image.png" alt="image.png" /></span></P><P>The crosstab tool changes the column header back to the latest month in case you need it like that.</P> Thu, 24 Aug 2023 11:56:53 GMT Christina_H 2023-08-24T11:56:53Z Automatic column selection and use in formula https://community.alteryx.com/t5/General-Discussions/Automatic-column-selection-and-use-in-formula/m-p/1179478#M9748 <P>When I update the EVDS excel, I want to automatically select the most recent column. Then, in the last part, I use this column as a coefficient in the formula. I have to do these manually. For example, I choose 2023-09, which I want to do this job after 3 months. then I edit it in the formula. How can I do this automatically?</P> Thu, 24 Aug 2023 11:37:51 GMT https://community.alteryx.com/t5/General-Discussions/Automatic-column-selection-and-use-in-formula/m-p/1179478#M9748 mkbayar 2023-08-24T11:37:51Z Re: Automatic column selection and use in formula https://community.alteryx.com/t5/General-Discussions/Automatic-column-selection-and-use-in-formula/m-p/1179486#M9749 <P>Try using a sample tool to take only the latest data from the transpose.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/320281iA3CED097E1A97936/image-size/medium?v=v2&amp;px=400" role="button" title="image.png" alt="image.png" /></span></P><P>The crosstab tool changes the column header back to the latest month in case you need it like that.</P> Thu, 24 Aug 2023 11:56:53 GMT https://community.alteryx.com/t5/General-Discussions/Automatic-column-selection-and-use-in-formula/m-p/1179486#M9749 Christina_H 2023-08-24T11:56:53Z