4 Replies Latest reply on Feb 8, 2019 5:27 PM by Adolfo Gorjon

# use dynamic table column to perform an operation and generate a new calculation

`I need to make a division between the data of 2 columns in a dynamic table, that is, the column CUP_VALUES with respect to years 17 and 18 is 16 and 23, we need to divide ((23/16) -1) * 100), Can this be done with a calmed metric with a dynamic table? and if it can be like?`

Versión del Producto Oracle Business Intelligence 12.2.5.0.0 (Build BIPS-20180909211754 64-bit) • ###### 1. Re: use dynamic table column to perform an operation and generate a new calculation

Hi,

if you use a pivot table then you can add a calculated column, cf example below - Step 2

https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCAA/Help/Insight/OtherTutorials/FormattingPivotTable.htm

• ###### 2. Re: use dynamic table column to perform an operation and generate a new calculation

Hello Robert, but that way I can not do it as specific in the example, since it does it with respect to the row or column and not a manual division as mentioned

• ###### 3. Re: use dynamic table column to perform an operation and generate a new calculation

A manual division?

If you mean inputting whatever number you like then you could have a calculated field that is driven by a presentation variable that is set by a dashboard prompt?

• ###### 4. Re: use dynamic table column to perform an operation and generate a new calculation

if it is necessary to divide the values of the column CUP_VALUES with respect to the years in this case 17 and 18 which have the value 16 and 23, I have to make a division of the value of 18 "23" / the value of 17 "16" subtract 1 and multiply it by 100 to give me the result in a new column, that wanted to know if it can be done with the dynamic table, since in a metric 2 columns of year are needed to make this division, and in my base I only have one 