Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
TOP 10 FILTER NOT WORKING
Summary
Trying to show top 10 voucher aging report
Content
Calculation: COUNT(DISTINCT VOUCHER_ID)
Alone it just shows 10 voucher rows. When added as filter it has not affect.
Using Table Control. Fields (Voucher ID, Voucher Aging (Days), OperID)
Filter Top / Bottom N Count 10, but I see 50 rows, all unique
Not sure what I am doing wrong
Version
18 cloud DVD
Answers
-
A random guess: is it possible that "# Voucher Count" has many duplicates inside?
A filter on Top10 keeps all the rows with the same value as the last one as it doesn't know how to pick by multiple rows with the some value. This could explain why you do see more than 10 rows while using a Top10 filter.
0 -
Should it work like PL/SQL Top 10?
0 -
It seems to work like a RANK function in the database and not DENSE_RANK. This is at least what I saw based on a quick test earlier.
0
