Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi you can try using dimensionality():
If(Dimensionality()=0, [Your Expression])
Or: If(Dimensionality()=0, [Your Expression],' ')
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!