Hiding a drill down dimension expression in pivot table

[#1]

Hi. I can't work out how to hide this expression (from my drill down dimension) in this pivot table:

I know you can hide titles and labels and expressions etc in some charts and graphs but I can't work out how to hide it in this pivot table.

I also have this problem with the getcurrentselections expression for a text box.

Thanks.

[#2]

Hi,

You can use Label attribute to set a generic name when you edit the pivot table instead of hiding or showing the expression. Hope this works for you!

[undergrinder]

Hi Chris,

No you can't hide at the moment, I don't know, whether it will changing or not.

Try create the hierarchy levels in load script.

mbalaji025‌: You're right, but with drill-down dimension that is a missing option.

G.

[#4]

Thank you both very much for your help I will try this out when I can and mark answered when I get the chance.

[#5]

Hi mbalaji025, I am confused about the image you have shown. My drill down dimension is called "ESA to JSID" and it shows the expression in tables and graphs as mentioned previously.

My properties panel shows the following:

This doesn't look like the options that you included in your post.

The drill down details are as follows and it's the first one that starts with =if(ESA_CODE....." that shows in the initial image that I included in my post.

Thanks