Display vertical labels in tables

Sometimes we have to display tables on a single page (or on a restricted number of pages).

The issue with this challenge is that the data to be displayed in a column is too large so the tables is displayed on multiple pages.

The hint is to turn the data vertically for a given dimension (or measure or detail).

To do it you just need to create a variable per dimension.

The generic formula is:

=Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([MyDimension];”a”;”a”+Char(10));”b”;”b”+Char(10));”c”;”c”+Char(10));”d”;”d”+Char(10));”e”;”e”+Char(10));”f”;”f”+Char(10));”g”;”g”+Char(10));”h”;”h”+Char(10));”i”;”i”+Char(10));”j”;”j”+Char(10));”k”;”k”+Char(10));”l”;”l”+Char(10));”m”;”m”+Char(10));”n”;”n”+Char(10));”o”;”o”+Char(10));”p”;”p”+Char(10));”q”;”q”+Char(10));”r”;”r”+Char(10));”s”;”s”+Char(10));”t”;”t”+Char(10));”u”;”u”+Char(10));”v”;”v”+Char(10));”w”;”w”+Char(10));”x”;”x”+Char(10));”y”;”y”+Char(10));”z”;”z”+Char(10));”A”;”A”+Char(10));”B”;”B”+Char(10));”C”;”C”+Char(10));”D”;”D”+Char(10));”E”;”E”+Char(10));”F”;”F”+Char(10));”G”;”G”+Char(10));”H”;”H”+Char(10));”I”;”I”+Char(10));”J”;”J”+Char(10));”K”;”K”+Char(10));”L”;”L”+Char(10));”M”;”M”+Char(10));”N”;”N”+Char(10));”O”;”O”+Char(10));”P”;”P”+Char(10));”Q”;”Q”+Char(10));”R”;”R”+Char(10));”S”;”S”+Char(10));”T”;”T”+Char(10));”U”;”U”+Char(10));”V”;”V”+Char(10));”W”;”W”+Char(10));”X”;”X”+Char(10));”Y”;”Y”+Char(10));”Z”;”Z”+Char(10));” “;” “+Char(10));”0″;”0″+Char(10));”1″;”1″+Char(10));”2″;”2″+Char(10));”3″;”3″+Char(10));”4″;”4″+Char(10));”5″;”5″+Char(10));”6″;”6″+Char(10));”7″;”7″+Char(10));”8″;”8″+Char(10));”9″;”9″+Char(10));”-“;”-“+Char(10));”_”;”_”+Char(10))

You just need to copy this formula and replace “[MyDimension]” by the appropriate dimension name, measure name or detail name.

Vertical labels.png

As you can see, the table can now be displayed on a single page or on a much more limited number of pages.

You can download the Web Intelligence report attached to that publication.

Didier MAZOUE

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

    1. Didier MAZOUE Post author

      Hi,

      I replace all characters in the dimension/measure/detail by adding Char(10) after each character: this will add a line feed after each character.

      Example: Replace([MyDimension];”a”;Char(10)) to add a line feed after each “a”.


      Didier

      (0) 
      1. varun garaga

        HI Didier,

        very nice Trick. could you explain more how it turned in to vertical?

        As you mentioned  it provides Line feed what do you mean by line feed

        Thanks,

        Varun

        (0) 

Leave a Reply