Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 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
Level measures (including percent to total)

Olivier Sinquin
Rank 4 - Community Specialist
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
0
Answers
-
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) )
0 -
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!
0