Categories
- All Categories
- 93 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.2K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 53 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
ACHV% sales achieved is showing wrong in sales achievement report in BIP
Reddy-87640
Rank 4 - Community Specialist
Summary
ACHV% sales achieved is showing wrong in sales achievement report in BIP
Content
Hi,
I have created this BIP report using pivot table view and all the totals are showing correctly in achv % sales achieved.
But at last the total level it is summing up all the columns and showing the total value instead to show the %of total sales achieved.
See the values below. it is calculating the ACHV % total .
Actually it should be ACHV% = YTDtarget/YTD ACHV. but it is not calculating the percentage
Can anyone help me how to solve this.
0
Answers
-
what is data source for this report ?
0 -
ApplicationDB_FSCM Default one.
0