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...
TOPN(Top 3 Errors Names, 3)
You need to use a unique identifier column for 'Top 3 Errors Names'
I was trying to give some idea so that you can put in your application dont expect exact column names unless you provided
Appreciate if you mark