Forum Discussion
mreidTNT
3 years agoNew Contributor II
How to leave Column Headers blank
Hi,
New user here. I have a report I'm building to show current year to date and prior year to date metrics, each with a variance column followed by a blank one as shown in the example screenshot ...
- 3 years ago
Can you try adding a space between the parenthesis after Name? So that your member filters would read A#None:Name( ) and T#POV:Name( ). It looks like it defaults to the member name unless you have a space in there.
molly_lvc
3 years agoNew Contributor III
Hello!
In order to show a blank column name, you would need to add a Name function to your cube view column.
For example, if your formula is T#2021M8, it would become T#2021M8:Name( ). Similarly, your view formula would be V#YTD:Name( ). It's essentially overriding the name to a space or blank value.
Hope this helps!
- mreidTNT3 years agoNew Contributor II
Hi Molly,
Thanks for your note. I sent the wrong screen shot. The one I sent was from a Revenue column. Below is an example of what I have for my blank columns.
Still returns the following names in the header spots within the columns.
- molly_lvc3 years agoNew Contributor III
Can you try adding a space between the parenthesis after Name? So that your member filters would read A#None:Name( ) and T#POV:Name( ). It looks like it defaults to the member name unless you have a space in there.
- mreidTNT3 years agoNew Contributor II
That worked! Thank you. Only missing part now is this YTD.
Related Content
- 3 years ago