3 Replies Latest reply: Oct 24, 2012 12:22 PM by Avinash P RSS

    How To Calculate Top3 for Every Month

    Avinash P
      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...