3 Replies Latest reply: Jun 10, 2013 10:11 AM by jonesswe RSS

    Why is "Suppress Zero-Values" failing?

      Hi,

      I have problems to show clients that dont have any invoices in a Pivot/straight Table chart. Under the Presentation tab, I have unchecked "Suppress Zero-Values" (have also tried all possible combinations of the settings), but without success.

       

      I have been able to recreate the problem in the small attached document. My simple data model looks like this:

      model.PNG

      I want to display the clientName as a dimension and sum all the sales for that client:

      chart.png

      My problem is that I have a client C that doesn't show up.

      I added the amount on invoiceLine level as a test during the troubleshooting and to my suprise;  Client C appears!

      chart2.PNG

      Why this behavior? Is it because the Amount column "is to far away" from the client?

      To test that, I merged invoiceLines and invoiceAccounts with a LEFT JOIN:

      model2.PNG

      =Sum(Amount) works now and Client C is visible?

      I need to know (I'm curious) why this behaviour. In my real document, the model is more complex and I hope that I dont have to merge the two tables. But if that is the only solution.....

       

      Best Regards,

      John