how to show break ups

[kunkumnaveen]

Hello all,

I need your help in achieving this requirement ,they want to show the current and previous audit score  location wise ,

which I am able to do that ,so the extension of this requirement is when end user click on current score or previous score then he should able to see break up in different quality wise ...what I mean is

      OVERALL_SCR     =      QUALITY_GOV, SAMPLING,LAB_ANALYSIS, FAIL_MGMT, SUPP_MGMT, RM_SPEC,MAT_MGMT,   LAB_INSTR_MGMT

All these fields are predefined fields ,In SCRIPT level what i try to do is

AuditScore:

LOAD MANDT,

     WERKS as WERK,

     date(ADATE,'MM/DD/YYYY') AS ADATE,

     QUARTER,

     OVERALL_SCR,

    QUALITY_GOV,

    SAMPLING,

     LAB_ANALYSIS,

     FAIL_MGMT,

     SUPP_MGMT,

   RM_SPEC,

     MAT_MGMT,

     LAB_INSTR_MGMT

FROM

(qvd);

table:

CrossTable(quality,values,1)

LOAD QUARTER, //(i just blindly took this quater field so that i can have association with top table)

QUALITY_GOV,

    SAMPLING,

     LAB_ANALYSIS,   //i am trying to group all these 8 fields in to one filed using cross table which i am success in doing that

     FAIL_MGMT,

     SUPP_MGMT,

   RM_SPEC,

     MAT_MGMT,

     LAB_INSTR_MGMT

     Resident AuditScore;

finally i want to show these two fields as shown in the last slide

RESULT :     

   qualityfield          values        

Expression :

current score

FirstSortedValue(OVERALL_SCR,-ADATE)

pervious score

FirstSortedValue(OVERALL_SCR,-ADATE,2)

please find the attachment and the raw data aswell