Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
ACHV% sales achieved is showing wrong in sales achievement report in BIP — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ACHV% sales achieved is showing wrong in sales achievement report in BIP

Received Response
6
Views
2
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!