4 Replies Latest reply: Oct 31, 2013 11:50 AM by Octavio Morales RSS

    Show zero values in straight table



      I have a straight table where I have 2 dimensions; ISBN number and Book. I then have an expression which is count (royalty ID) where 1 royalty ID equals one listening. In this table values only shows up i royalty =1 or higher, i.e. if the book hasn't been listened to it doesn't show up but I want to see all titles when I filter for e.g. for publishers. Do you know if this is something I should fix in the script or in the layout view?


      I try to untick "suppress zero values" and "suppress missing values" but this doesn't help. I also try to tick the "show all values" in the dimension tab in the table.


      Thankful for help!