2 Replies Latest reply: Sep 18, 2013 4:06 AM by Gysbert Wassenaar RSS

    Dimension expression shows repetitive values.

      Time_interval Year 2011 Year 2012
      4:30 - 5:00                     24                     18  
      5:00 - 5:30                2,975                 3,504
      5.30 - 6.00                6,933               10,307
      6.00 - 6.30                9,154               10,359
      6.30 - 7.00              22,365               18,003
      7.00 - 7.30

                 19,416

                  131,800

       

      Hello, I have three dimensions. Time_interval, ArticleNo and Year. I need straight table as above. I'm not getting desired output as above, when i use the below query for Year.

       

      Year 2011 expression --------     =Aggr(NumericCount(ArticleNo), Time_interval, Year=2011)

      Year 2012 expression --------     =Aggr(NumericCount(ArticleNo), Time_interval, Year=2012)

       

      I somehow gets the answers, but i get repetitive Time_interval values. like below. Please help me. Thankyou.

       

      Time_interval Year 2011 Year 2012
      4:30 - 5:00                     24                     18  
      4:30 - 5:00                2,975                 3,504
      5.30 - 6.00                6,933               10,307
      5.30 - 6.00                9,154               10,359
      6.00 - 6.30              22,365               18,003
      6.00 - 6.30

                 19,416

                  131,800