7 Replies Latest reply: Feb 26, 2016 6:28 PM by Stefan Wühl RSS

    Newbie question: how to preserve dimension values when filtering

    PAOLO MAPELLI

      Good Morning,

      sometimes I get stuck into a simple problem, without reach out a solution...

       

      I have a table like this:

       

      Customer     Month     Revenue

      A                 Jan         100

      A                 Feb         100

      B                 Jan         100

      C                 Jan         100

      D                 Jan         100

      D                 Feb         100


      Of course if I select "Feb" as month I get:

       

      Customer     Month     Revenue

      A                 Feb         100

      D                 Feb         100


      But I'd like to have this:


      Customer     Month     Revenue

      A                 Feb         100

      B                 <null>     <null>

      C                 <null>     <null>

      D                 Feb         100


      In other words, I'd like to have customers always shown, even they haven't revenue for that month.


      Any suggestion ?


      Thanks in advance.


      Paolo.