Forum Discussion
Solved
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 ...
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.
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.
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.
That worked! Thank you. Only missing part now is this YTD.
Hello,
I am not sure if this is already solved. But in order to remove the YTD in the third row of the column header, can you try to add :V#YTD:Name( ) to the T#POV:Name( ). The entire member filter will become: T#POV:Name( ):V#YTD:Name( ).
Please let me know if this solved the issue!
Thanks.
Kind regards,
Floris van der Poel
Hi Floris,
Thanks for the reply. That unfortunately returns the following error:
I don't think it works b/c in this example, I'm using two different member filters that tie to two different Primary Dimension Types (Time and View).
Assuming I can't have two Primary Dimension Types, is there a way to add a Nested Member Expansion 3? Also, If I change Nested Member Expansion 2 to the View Dimension and use V#YTD:Name( ), I get this:
Thanks,
Michael
