Oracle Analytics Cloud and Server

Products Banner

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

Received Response
41
Views
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

image

Can anyone help me how to solve this.

Answers