Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
%Increase in pivot view
Hi all,
How to evaluate % increase in pivot view.
i have a measure1 (2016 data) and measure2 (2015 data) columns
i want %increase = (measure1-measure2)/measure2 using pivot view.
Is it possible in pivot view?
Regards,
Ram.
Answers
-
Hi,
You could create a year ago measure to achieve this, or, if you are set on your pivot table course then you can make calculations by referencing the columns in a newly created calculated column; -
“($1 - $2) / $2”
Hope this helps?
Robert.
0 -
hi,
how to create calculated column for measures in pivot view?
i tried to create calculated column for measure it is saying cannot be created for measures.
regards,
ram.
0 -
My example syntax assumes that your years are laid out in columns and the year 2016 is in column 1 and 2015 in column 2.
On pivot table calculations you would do it as follows; -
To create a calculated item for a dimension column (in your case I am guessing something like Time.Year)
Click on the “More options” button for the dimension column
Choose “New Calculated Item”
Populate with the formula as previously supplied.
Got it?
0