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

Reddy-87640

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.

Venkat Thota - BIP

what is data source for this report ?

Reddy-87640

ApplicationDB_FSCM Default one.