Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Level measures (including percent to total)

Received Response
41
Views
2
Comments
Olivier Sinquin
Olivier Sinquin Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

Level measures (including percent to total)

Content

What is the syntax for level measures in DV?

For example let's say I have some sales data by region, what is the syntax to get total sales across all regions, no matter what the filtering is.

This could be used to create a percent to total by region measure  : sales/total sales

Answers

  • Olivier Sinquin
    Olivier Sinquin Rank 4 - Community Specialist

    yes that's right and I also learnt the advanced version of it , where we add a BY clause (e.g.  Sales/SUM(Sales by Whatever) )

  • Luke Sharma
    Luke Sharma Rank 4 - Community Specialist

    Hello there,

    From the sounds of it you should just be able to do Sales/SUM(Sales) - The SUM(Sales) should give you the total number of sales in the table. This should ignore the filter settings for the calculation.

    Please let me know how you get on!