Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help needed to auto create monthly columns from quarterly columns

charlenemx1022
6 - Meteoroid

Hello,

 

I am looking for an easier way to create 12 new monthly amount columns from 4 quarterly amount quarters (equally division) without having to manually using 12 formula tools. Thanks!

6 REPLIES 6
binuacs
21 - Polaris

@charlenemx1022 can you provide more information or sample input and output for better understanding?

charlenemx1022
6 - Meteoroid

Sorry about that. Yes. I have Q1,Q2,Q3 and Q4 columns and I would like to create 12 new monthly columns for Jan-Dec with the monthly amount (Quarter amount /3) without having to use 12 formula tools. Thanks! 

binuacs
21 - Polaris

@charlenemx1022 one way of doing this

image.png

charlenemx1022
6 - Meteoroid

Thanks so much!

charlenemx1022
6 - Meteoroid

Is that a reason why you used a Dynamic Select instead of a Select? 

binuacs
21 - Polaris

It is more dynamic than select tool

Labels
Top Solution Authors