Following are the steps to display top 5 values in an OBI EE Report :)
Process 1:
1. Select District ,Dollar and Dollar columns from Markets and Sales Measures tables, rename one of the Dollar column to Rank.
2. Sort the Dollar column in descending order using OrderBy in Criteria Tab.
3. Select Edit formula of Rank column, and apply the TopN function, to filter the top 5 values.
TOPN("Sales Measures".Dollars, 5)
4. View the results.
Process 2:
To Display top 5 highest salaried employees in an OBI EE Report.
Using "Add filter " column property in Criteria tab.
Process 1:
1. Select District ,Dollar and Dollar columns from Markets and Sales Measures tables, rename one of the Dollar column to Rank.
2. Sort the Dollar column in descending order using OrderBy in Criteria Tab.
3. Select Edit formula of Rank column, and apply the TopN function, to filter the top 5 values.
TOPN("Sales Measures".Dollars, 5)
Process 2:
To Display top 5 highest salaried employees in an OBI EE Report.
Using "Add filter " column property in Criteria tab.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.