Oracle Analytics Cloud and Server

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

Cannot produce a summation of values of a particular column

Received Response
145
Views
2
Comments

Content

Hi team,

 

      I have created a pivot table consisting of attributes and values as percentage, in which I want to calculate grand total of values of a particular column by right clicking on that row/column and clicking on 'Show Total'. But here as I am right clicking on the row , the 'Show Total' is not being displayed. Hence , I am unable to calculate the summation of the values. I have uploaded an image of it. 

Please suggest me how to get through this or are there any other alternatives.

 

Thanks

 

Ankan

Screenshot (183).png

Answers

  • Setting Totals on columns and rows is done in the properties panel

    InkedScreenshot_(183)_LI.jpg

  • Rank 5 - Community Champion

    You may need to add columns as part of the Summation values. Additionally, OAC might not allow a summation across the columns because of the column types. It looks like you're summing ratio's which can result in unexpected values.

    6-29-2021 2-43-51 PM.png

Welcome!

It looks like you're new here. Sign in or register to get started.