We have a table of some products with category and amount. We need the Projected amounts based a growth rate. Using

We want the projected amounts based on a growth rate. Dynamic Arrays is used to fill out this column.

Now source table is filtered based on Amount (<4000) using Dynamic Arrays.

Finally, projection based on different growth rates again using dynamic array features: