4 Replies Latest reply: Feb 15, 2014 12:57 PM by Manish Kachhia RSS

    getting unexpected result using Set analysis

      Hi All,

       

      I am having a source table like this

      Itemkeyprice
      A2/15/201334
      A1/16/201335

       

      Loaded using the following script

      LOAD Item,

           key,

           month(date(key,'YYYYMMDD')) as Month,

           price as Price

      FROM

       

      When I tried to make a straight table with Item and Month as dimensions, Sum(Price) and Sum({<Month=>}Price) as expressions I am getting the same value over both the expressions as below.

      ItemMonthsum(Price)sum({<Month=>}Price)
      AJan3535
      AFeb3434

       

      I was expecting 69 in the fourth column for both rows.

       

      can someone explain it please.