Why does the overall sum of the table chart is not showing the correct sumed value ?
As per the attached image the sum of the column at the right end is not showing the summedup value in the overall sum value. When I change the Totals function to sum its correct but based on calcuation logic the overall value is becoming wrong i.e. sum(AB) * Percentage(Ist/WUs ) should be equal to my right end column value
i.e. when I sum up the column value it should be equal to overall sum(AB) * Percentage(Ist/WUs ).
It will be great help if some one can help me to solve this issue.