Issue in totaling pivot table

[engr_farhanqadr]

Dear Folks,

I have a pivot table in which I am showing the totals of each row at right. In Total Cost row the total is coming wrong.

I have two dimensions Director and Branch. what could be the possible solution of this issue.

Thanks

[tresB]

Try your expression constructing with additional sum() like:

Sum(Aggr( <ExistingExpression> , Director, Branch))

[andrey_krylov]

Can you share your expression?