Oracle Analytics Cloud and Server

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

Received Response
51
Views
2
Comments
Reddy-87640
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

image

Can anyone help me how to solve this.

Answers