expression unshow

[#1]

Hi,

I need some inputs on the pivot table expression hide.

I need to hide the Actual column for FULL YEAR dimension.

the actual column for PERIOD & YEAR-TO-DATE should remain the same.

Any help would be highly appreciated!!!

[jagan]

Hi,

Please find attached file for solution.I did this for Actual and Budget you can try the other parameters.

Regards,

Jagan.

[#3]

hI Jagan

thanks for the suggestion unfortunaltey i tried the expression i am not able to generate the values

plese find the app where i have created formulas for other expression

Do needful

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Regards,

Jagan.