3 Replies Latest reply: May 24, 2012 9:23 AM by Roland Kunle RSS

    Missing months in a chart

    Frédéric Villemin

      Hi,

       

      this is probably one of the silliest question of this forum but i still can't find a good solution :

       

      i have a datasource with projects and products by month

       

      month, project, product, amount

      2012/01, P1, Product1, 10

      2012/01, P1, Product2, 10

      2012/02, P1, Product1, 20

      2012/03, P1, Product1, 30

      2012/03, P1, Product2, 50

      2012/04, P2, Product3;100

      and many other lines for many projects and many months

       

      When i make a chart with Project P1 select, i have all three months

      But if i select only product2, i will only see 2012/01 and 2012/03 with no mention of 2012/02

       

      In the chart i could unselect "Suppress zero values" but it seems i would get the 2012/04 month from Project 2 and i don't want that

       

      How can i do ?

      I have tried with a master calendar but it doesn't seem to work

      And with formulas in the Month dimension, neither

       

      Thanks