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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 |