topic Re: Hiding a drill down dimension expression in pivot table in App Development

Hiding a drill down dimension expression in pivot table

Fri, 17 Jun 2016 01:33:12 GMT

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.

Re: Hiding a drill down dimension expression in pivot table

Fri, 17 Jun 2016 17:48:25 GMT

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!

Re: Hiding a drill down dimension expression in pivot table

undergrinder — Sun, 19 Jun 2016 09:02:53 GMT

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.

Re: Hiding a drill down dimension expression in pivot table

Mon, 20 Jun 2016 06:53:14 GMT

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

Re: Hiding a drill down dimension expression in pivot table

Wed, 22 Jun 2016 01:55:05 GMT

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