Oracle Analytics Cloud and Server Idea Lab

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

Add the Total() function to use in Viz calculations.

Needs Votes
11
Views
0
Comments
Rank 6 - Analytics Lead

Currently OAC supports only SUM() function but not TOTAL() function.

Qlik is having this functionality and it is very useful in calculating the averages.

Below is the usage.

  • Examples:
    • Sum(Sales): Sums sales for the current selection and dimensions. 
    • Total(Sum(Sales)): Returns the total sales for all data, ignoring selections and dimensions. 
    • Sum(Total <Category> Sales): Returns the total sales for each category, ignoring other dimensions. 
    • Sum(Total Sales): Returns the total sales for all data, ignoring selections and dimensions. 

In essence, Total() provides a context-free total, while Sum() calculates the total within the current context. 

Use Cae:

Help in calculating variance dynamically in Table/Pivot table. — Oracle Analytics

2
2 votes

Needs Votes · Last Updated

Welcome!

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