Hello! I'm fairly new to Alteryx and tried to use the search feature, but struggled to find anything relevant to the issue I'm currently facing.
I have a data set that shows daily data for a list of companies over the course of 5+ years. As an example, see the following:
Company | 2014-06-01 | 2014-06-02 | ... | 2021-06-01 |
Company A | 100 | 130 | ... | 250 |
Company B | 70 | 40 | ... | 10 |
Company C | 90 | 100 | ... | 200 |
I'd like to summarize this data by year for each column such that the end output looks like this:
Company | 2014 | 2015 | ... | 2021 |
Company A | sum(values for 2014) | sum(values for 2015) | ... | sum(values for 2021) |
Company B | sum(values for 2014) | sum(values for 2015) | ... | sum(values for 2021) |
Company C | sum(values for 2014) | sum(values for 2015) | ... | sum(values for 2021) |
My hunch is that some combination of transposing the data, using a trimleft(), and then joining the data back would help me get closer to a solution, but I'm struggling to figure it out complete. Any advice would be greatly appreciated. Thank you!
@shmeyers
This would be the good fit for Transpose and Cross Tab.