How to present blank cells instead of "(none)" values on planning views

[Former Member]

Dear community,

Would anybody have the pleasure to inform me of how to present blank cells instead of "(none)" values on a planning view?

Best regards

Vasilis

[anamika_mudgal · Accepted solution]

Hi Vasileios,

Are the 'none' cells for any attribute? Is it  a non attribute? Or is it showing for base version ?

Regards,

Ana

[Former Member · Accepted solution]

Hi Anna,

It was my mistake to hide the headers. The none values concern attribute

Regards

Vasilis

[anamika_mudgal · Accepted solution]

Hi Visileios ,

Go to EPM edit report --> member names -->select the attribute in dinensions  -->select 'none' in members ---> override it with sapce.

Hope you can resolve now

Regards,

Ana

[Former Member · Accepted solution]

Hi Ana,

Thank you very much! That was it!!

[OliverA41 · Accepted solution]

Hello,

this information is from 2016. How can I customized this in the latest excel Add-On ?

Regards

Oliver

[piyush_parekh · Accepted solution]

Hi Oliver,

Follow below steps.

About > Settings > Options > Member Names > Select your attribute from Member selection dropdown. > Select (None) from the list > In new name for member enter space and click on Override > OK > Update the template.

Regards,

Piyush