How do I hide values in a pivot table but only show them at the top level budget line?

[Chrisc0276]

Hello all, I have created a Pivot table that I would like to use to show Forecasted Spends. However, I do not want to see the Approved amount and the Unobligated Amounts on any of the lines except the Top level line.

How do I perform this action?

[rubenmarin]

Hi you can try using dimensionality():

If(Dimensionality()=0, [Your Expression])

Or: If(Dimensionality()=0, [Your Expression],' ')

[Chrisc0276]

Thank you for the advice. I will have to bring this to our contractor helping me with this as this is over my head.  I need a manual or guide book.  Thank you again!