2 Replies Latest reply: Jan 12, 2017 12:36 PM by Sunny Talwar RSS

    Block dimension so it will not be filtered by other dimensions

    Antonio Carbonell

      Imagine that I have a table like this:

       

      DateCountryincome
      Day 1Spain100
      Day 1Norway100
      Day 2Norway-
      Day 3Norway300

      * On day 2 in norway  there is no income, the model does not cross

       

      I create a filter that is Country

      And I have an evolution chart where I show the income:

       

      Day 1 -> 200

      Day 2 -> 0

      Day 3 -> 300

       

      (I have disabled the option "Do not show null values")

       

      Filter by country = Norway and I want it to appear:

       

      Day 1 -> 100

      DAY 2 -> 0

      Day 3 -> 300

       

      However I still have:

       

      Day 1 -> 100

      Day 3 -> 300

       

      How can I block the date dimension (i need show day 2 with income value = 0) so that no value disappears when filter by country, either because it is 0 or because it has no value?