10 Replies Latest reply: Dec 3, 2012 10:32 AM by Ivelin Iliev RSS

    Split data for specific cells only

      Hello,

       

      I have the following data:

       

      TitleDwnIDTypeDownloads
      Title11same20
      Title21same0
      Title32same40
      Title42same0
      Title53dif60
      Title64dif80

       

       

      and I want to split the Downloads for titles which have the same DwnID:

       

      TitleDwnIDTypeDownloads
      Title11same10
      Title21same10
      Title32same20
      Title42same20
      Title53dif60
      Title64dif80

       

      If I use Sum({<Type={'same'}>} Downloads/2) I get the right values for Titles which already have a Downloads value but for the rest the value stays '0'.

      Any suggestions?

       

      Kind Regards,

      Ivelin