total column row should have only total amount value

Summary:

In Report we are using Pivot table and there is amount column so doing total of the row , but the total row is giving again entire row values.

Providing sample screenshot for reference.

Content (please ensure you mask any confidential information):

so here the green highlighted row is total column for Trans-A and A but that total row is also having values and that is dummy row it is giving so how can we get only Trans-A total in the row and not that dummy values before it.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):