ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Repeat Values in all rows

7 - Meteor

Hi everyone, 


Can someone help me figure out a way to repeat all the values in the "Sum_TotalEmpl" column for Dec into all the rows? 


So what I want is to for example I want the 3,812 number to show in row 11 the same even though it is Apr






17 - Castor


Something like this?


10 - Fireball

Hi @JonaV,


This is one way to do it:

Screen Shot 2021-02-23 at 7.50.42 PM.png


I hope this helps. Best!

7 - Meteor

I've attached the Excel output file from my workflow.


So, essentially what I want to do is to repeat the "Sum_Total_Empl" for every record so that I can make a calc that takes the Ext Hires (excl Sep) and divides it by the PREVIOUS YEAR End total. For example, in row 12 I want the calculation in cell H12 to be 48/3812 (or E12/D12)

13 - Pulsar

Hi @JonaV 


Is this what you are looking for?







7 - Meteor

Doesn't look like it.


I want the "Sum_Total Empl" numbers for the first 10 records to show in the next 10 records.+


So, I want the 2017 Year End numbers (Dec) to show in 2018, the 2018 show in 2019 and so forth - for every month I want the Prior Year DEC numbers to show. The DEC numbers are my baseline for the calculation for every single month for every single record


Hope that makes sense

10 - Fireball

Hi @JonaV,


I have a better understanding of your goal now. Please check the attached workflow. Best!

Screen Shot 2021-02-24 at 1.09.36 PM.png