Display vertical labels in tables

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.

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