Post reply

How to show empty cells (rows) in Excel Spreadsheets that connected to SSAS

  • March 29, 2011 at 8:58 pm

    #233936

    Hello,

    I have an Excel sheet connected to SSAS 2008.

    In the SSAS cube, I have an option that shows/hides empty cells. Does anyone know how to show empty cells in Excel? (by default, my spreadsheet hides the empty cells/rows.)

    (Please see attachment)

    Thanks in advance!

    wwei

  • March 30, 2011 at 6:00 am

    #1305371

    Under Pivottable options .. select the tab labeled "Display". There is an option called "Show items with no data in rows". Put a check mark by that one. Under the "Layout and format" tab, you can also indicate a value (optional) that you want to appear for blank cells (i.e. "n/a").

  • March 30, 2011 at 8:57 am

    #1305487

    Hi randy.jaye,

    Thank you so much!!! It works just like your said.

    Best Regards,

    Wei

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply