Trying to remove unwanted line in Pivot Table and Divide amount by Percentage

[mattdavis10]

Hi,

I have a value that is not linking with one of my dimensions creating a separate line when expanding my pivot table. I'm trying to get that line to be removed when expanding the pivot table and the amount "Undistributed Balance" to divide under the "Account" Dimension by the "Account Percentage". Let me know if this is something that can be done.

Thank you

Matt Davis