Comments on: Mind the gap! ../../../../2012/09/mind-the-gap/ XLCubed Blog Fri, 04 Jan 2019 11:31:26 +0000 hourly 1 https://wordpress.org/?v=5.3.21 By: arno ../../../../2012/09/mind-the-gap/#comment-235 Thu, 25 Oct 2012 15:44:19 +0000 http://blog.xlcubed.com/?p=3645#comment-235 To avoid issues when printing in black and white one could create a calculation named ” ” (one or more spaces) or use a number format like “;;;” to make the name of the empty row or column invisible!

Thanks to Craig Salter from xlCubed for this!
arno

]]> By: xlcubedblog ../../../../2012/09/mind-the-gap/#comment-234 Thu, 13 Sep 2012 14:44:19 +0000 http://blog.xlcubed.com/?p=3645#comment-234 Hi Christian,

Thanks for your comment.

You could change the calculation to something like:

iif(IsEmpty([Date].DefaultMember), null, ‘ ‘)

You could change [Date].DefaultMember to a specific year to check for the presence of data.

Thanks!

]]> By: Christian Fürstenberg ../../../../2012/09/mind-the-gap/#comment-233 Thu, 13 Sep 2012 07:30:57 +0000 http://blog.xlcubed.com/?p=3645#comment-233 Hi,
This is a nice trick. But you are running in trouble with the zero supression on rows. If a row element has no values, the zero elements are not supressed, because of the calculated member in the column. Is there a good workaround for that issue?

]]>