Creating Dynamic Rows and Columns

[taylormgruendel]

Hi All,

I'm looking to generate new columns based on using the numbers from the previous column to find the averages. Each new record in the column will have the previous column(s) numbers added together to find the average and placing that new average in the new column.

My issues I'm running into:

- How can I create a looping function to generate columns?

- How can I call multiple records dynamically in order to use these values for the new column?

Below is what I'm trying to accomplish without creating static variables. 

1. Creating a new field

2. Each new column adds one more extra record to the Avg() calculation

Any thoughts on how to do this? Thanks!

[NoelCarson]

You may use the Generate Rows tool and then CrossTab it.