community
cancel
Showing results for 
Search instead for 
Did you mean: 

community Lounge

Get to know your fellow analytics buffs and discuss a wide range of topics!

Dynamic field names from cross tab output

Atom

I have recently started using Alteryx, so this is a beginner question. 

 

I have some data where the columns are a mixture of strings (names and products), doubles (values and amount) and dates (N number of month-ends). I wanted to take the date column and use the values in the column to be shown as separate columns and then values for the rows in that column to be the sum of the values.  This is so the data shows monthly totals side by side and their variances. 

 

In order to do that I have used cross-tab, followed by a formula box to find the difference in values between two dates, and that works fine – but in the formula box I hard code the dates.

 

However, next month the dates will change, so I’m not sure how to make this dynamic so that after the cross-tab the flow of the data still works and doesn’t rely on me hard coding dates?

 

Alteryx Certified Partner

can you post up a sample of your data?