The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

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