This discussion is archived
3 Replies Latest reply: Oct 24, 2012 10:22 AM by Avinash P RSS

How To Calculate Top3 for Every Month

Avinash P Newbie
Currently Being Moderated
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...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points