2 Replies Latest reply on Oct 14, 2018 10:13 PM by Priyanka Jose

    calculation creation help

    Priyanka Jose

      Hi,

       

      Below is the sample table which I use to create a sheet. I have a date parameter. If the datepart('month',date_parameter) = month then I want the unique value for that  month ie 298 if the month is 9.

      I tried fixed but aggregate seems to be an issue. max,avg isn't helping.

      Can someone guide me through this?

       

      Thanks:)

       

      namemonthtarget
      abc9298
      def9298
      ghi8301
      klm8301
      nop9298