Create a column with a parameter

Question & Answer
1

I try to explain better. I have a table with column relative to a number of product to sell for example:

product1. | product2. | product 3. | total
10 | 10 | 10 | 30

I want to create a series of column based on a value choose by a control for example:
i choose 40 the result need to be:

product1. | price product1 | product2. | price product2 |product 3. | price product 3. | total. |tot price
10 | 400 | 10 | 400 | 10 | 400 | 30 | 1200

if i choose another value i need to produce dynamically the columns.

Is it possible?

2

yes you can use parameters in calculated fields. A calculated field is a new column.

image
image1514×653 21.8 KB

Is that what you’re asking?

1 Like
3

Can i Dynamically change a column name based on a parameter value.
Say current week is 30 and I have 10 columns - so it should change dynamically to 31, 32, 33, 34, 35,… etc.

Col T+1 - > Wk 31
Col T+2 - > Wk 32
Col T+3 - > Wk 33
Col T+4 - > Wk 34
Col T+5 - > Wk 35
…