3 Replies Latest reply on Oct 24, 2012 5:31 PM by Srini VEERAVALLI

    How To Calculate Top3 for Every Month

    Avinash Pentyala
      Hi,

      I have 3column Like This MonthName ,RootCause, No Of SRs...
      Month name values jan,fed,march....dec
      Root Cause haveing Differnt types Of Errors.
      No Of SRs is Fact colomun

      Now i want Display Top3 Errors In Every month Based On SRs.
      I worte Like This In Edit Formula Of Factcolumn

      TOPN("Service Request Facts"."# of SRs", 3) But It Will Showing 2month values and only one Record.

      Plz Any Help...