Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to Calculate % for a TopN records
Hi,
I want to calculate percentage for a column which is picking TOPN records in a column.
I have a column called AP Amount from which I am picking top 10 records by using TOPN function. I created another calculated measure called % AP Amount in which I need percentages in this column with respect to the AP Amount. Please guide me how to achieve this.
Thanks
Answers
-
Just add a duplicate layer column of AP Amount and select show data as percent of column.
0 -
Thanks Mate !!
You made my day...been working on this over a week.
0 -
An extended question...
How to customize the column names, as both the columns are representing the same names. Just like Revenue in your screenshot.
0 -
Format Headings
0 -
Hi,
How to reflect/pass the data in the duplicate layer to the graph or to a column which can influence the graph. The value in the % Overdue to Total is being calculated on a whole but I want only for TOPN.
Please notice the difference in values for the same AP Overdue Amount.
Thanks
0 -
Hello,
In the same pivot table you will find an option to create chart at the end. Use it and select line bar. It will work.
0 -
Thanks!!
How could I add It to the view, where a drop down will be provided to select between graph or table.
0 -
View selector
0