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

Question

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)

Adolfo Gorjon · Answer

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

Robert Angel · Answer

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?

Adolfo Gorjon · Answer

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