4 Replies Latest reply: Aug 29, 2012 7:29 AM by Yves Sannen RSS

    Show all values

    Yves Sannen

      Hi all,

       

      I've got something that I cannot find how to do.

       

      I've made 2 pivot tables, both have the same dimensions: Week and City.

       

      In the first, I have the expression sum(Turnover).

      In the second, the expression is Count(DISTINCT InvoiceId)

       

      for weeks 33, 34 and 35, turnover number of invoices are 0.

       

      When I select 2012 as year and august as month (weeks 33, 34 and 35 belong to august),

      in the first pivot table I get a column for all the weeks, including 33, 34 and 35, where I get all 0-s. This is GOOD.

       

      In the second pivot table however, those weeks are not displayed, but I want them to be displayed with 0's.

      If I check the 'show all values' for the dimension week, I also get all the weeks that aren't related with the month I selected.

       

      It seems there is a diference depending on the fucntion I use (sum or count).

       

       

      Any one an idea how I can get this to work with the count?

       

       

      Regards,

       

      Yves