This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Just getting started with Altryx and have a question - I have a query selecting the prior 3 months of data, I am creating a crosstab in Altryx using the dates as the column headers. I am then creating a new column using a formula but am struggling to figure out how to do this without explicitly naming the columns? I would like the formula to dynamically select the prior two months and subtract the two months columns from each other. So, [06_01_2019] - [05_01_2019] but I don't want to have to update it each month manually. I would imagine this is simple but I didnt find anything relevant searching for a solution.
Good solution from @MichalM. From the description of your process it looks like you should apply the multi-row formula before you perform the cross tab. That way the cross tabbed data will already have the formula applied to it.
The problem I have with not cross-tabbing the data is there are multiple data elements that will not always line up correctly when subtracting the row above. For example when the tax type or geocode changes the row above will yield an incorrect MoM variance. Will the group by values in the multi-row formula keep the groups together and not cause incorrect results. So the formula will only subtract from the row above based on the group by values selected being equal? In the sample data below when the geocode or the tax type changes for example. I will try and experiment with it and answer my own question later today. Much appreciate the helpful advice.