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

Rajakumar Burra

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