How to displaying Account without amount? RRS feed

  • Question

  • Hi,


    I need to display BS/POL account in a workbook even if there are no amounts för the account. Is there any way to show 0 .

    Now I get

    2010    50

    2040    75

    I would like to have:

    2010    50

    2020      0

    2030      0

    2040    75

    Wednesday, September 28, 2011 12:45 PM


  • You can create another calculation to check is the value of the measure is BLANK() and if so, output a zero.  As an alternative, you can change the pivot table configuration by right clicking on it, selecting PivotTable Options, Display, and then check 'show items with no data on rows'

    The first option will give you zeros, the second one will show all row labels but empty cells on values

    Javier Guillen
    • Marked as answer by Larra Thursday, September 29, 2011 8:20 AM
    Wednesday, September 28, 2011 8:59 PM