Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

Adding blank row/Column

Is there a way to add a blank row/column within Cube View? I know it can be done, but can't seem to remember the code. I believe it was "|!Blank|"....

 

Thank you!

Cube View
  • ChristianW's avatar
    ChristianW
    Valued Contributor
    4 years ago

    There is no blank row command, I always use (or add) A#None to the pov to get an empty row. |!Blank!| is a parameter with all the formatting option to give background and font the same color (white, transparent or any other color). You can create the parameter on your own, or you can download a predefined set of formatting parameter from the market place.

    • CAIGuySeanF's avatar
      CAIGuySeanF
      Contributor
      3 years ago

      Hey Christian,

      I also use this syntax, but have a quick view with row suppression on.  Is there a way to cheat in a blank row with suppression on?  I can't seem to solution one and saw this post.  Have you come across this before?

    • EmilieDurand's avatar
      EmilieDurand
      New Contributor II
      2 years ago

      Hi Christian, 

      I used your solution of A#None, however, is there a way to get rid of the dimension icon on the left in order to have a fully blank line?

      Thanks, 

  • JohnMorehead's avatar
    JohnMorehead
    New Contributor III
    4 years ago

    I second what Christian said, put in an intersection that you know will never have data, like A#None, and it will always come back blank.