Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Displaying Data Labels for the latest Month
Hi All,
I have a Pivot table where horizontal axis is Month ,vertical axis is Brand and revenue as measure and have a line graph created based on the pivot table. what I did is Opened Chart Properties -> Title and Labels - > Data Markers -> Display Options -> Show Data Labels ->Show Always. So what happening is its displaying the revenue values at different monthly points.
What my requirement is to display only latest month revenue figures and suppress all other revenue data markers??. Thanks in advance
Thanks
Raj
Answers
-
Hi Raj,
I guess this would be a tool limitation. But one Question from my side if you want to display the latest month data on chart why can't you filter.
Thanks
Krishna
0 -
As Krishna said it's not doable ... the setting is "always" or "never" (ok, on mouse over).
0 -
Hi Krishna,
Basically there is pivot table data with say last six months data and I am converting the pivot table data view to chart view so having last six months data displayed on line chart. of which customer wants to display the data labels only for last month.
Thanks
Raj
0 -
Yes, so his first answer (not possible) still apply.
He was asking because maybe you wanted in the chart only the last month and not the previous ones.
But you want the 6 months and showing the value of last month numbers next to where your lines end (and that the not available option)....
0 -
Create two seperate analysis one for pivot and another for chart and keep it in same dashboard page
0
