ACHV% sales achieved is showing wrong in sales achievement report in BIP
SummaryACHV% sales achieved is showing wrong in sales achievement report in BIP
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.