Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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)
Answers
-
Hi,
if you use a pivot table then you can add a calculated column, cf example below - Step 2
0 -
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
0 -
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?
0 -
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
0