Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Is there a way to calc the diff between to "% of Column" columns in a pivot table

Received Response
2
Views
1
Comments
2767084
2767084 Rank 1 - Community Starter
in Oracle Business Intelligence Applications

(In Hyperion Interactive Reporting)

I have a column of "this year sales" with the "% of column" function and a column of "last year sales" with the "% of column" function.

Now I need a column that shows the difference between those 2 percentages.  When I do the computed with "Column1 - Column2", the difference it produces is the difference in the raw sales numbers, not the difference in percentages.

How can I get the difference in percentages?

Thanks.

Answers