Forum Discussion

mreidTNT's avatar
mreidTNT
New Contributor II
3 years ago

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 ...
Cube View
  • molly_lvc's avatar
    molly_lvc
    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's avatar
molly_lvc
New Contributor III
3 years ago

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!

  • mreidTNT's avatar
    mreidTNT
    New Contributor II
    3 years ago

    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_lvc's avatar
      molly_lvc
      New Contributor III
      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.

      • mreidTNT's avatar
        mreidTNT
        New Contributor II
        3 years ago

        That worked!  Thank you.  Only missing part now is this YTD.