Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try your expression constructing with additional sum() like:
Sum(Aggr( <ExistingExpression> , Director, Branch))
Can you share your expression?