Categories
- All Categories
 - Oracle Analytics Learning Hub
 - 19 Oracle Analytics Sharing Center
 - 17 Oracle Analytics Lounge
 - 233 Oracle Analytics News
 - 44 Oracle Analytics Videos
 - 15.9K Oracle Analytics Forums
 - 6.2K Oracle Analytics Idea Labs
 - Oracle Analytics User Groups
 - 87 Oracle Analytics Trainings
 - 15 Oracle Analytics Data Visualizations Challenge
 - Find Partners
 - For Partners
 
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
                
                    2767084                
                
                     Rank 1 - Community Starter                
            
                        
            (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.
0