Forum Discussion

rquizon09's avatar
rquizon09
Frequent Visitor
1 year ago

Exam Item Analysis

Hi, Newbie here.   How can I sum the Item No.1 based on the Score Column. But before to get the SUM of Item No. 1, I need to Sort Descending order the Score Column because I need only those top N ...
rquizon09's avatar
rquizon09
Frequent Visitor
1 year ago

Hi bhanu_gautam 
I already get the unique ranking every row.
I want to SUM now the Item No.1 based on the Ranking. but the problem is the ranking is equal to 27% of the total count rows per subject. Meaning, the count or ranking will be dynamic.

Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi rquizon09 

     

    Thanks for the reply from bhanu_gautam .

     

    rquizon09 , if your problem is still not solved, could you please explain in more detail what you mean by "but the problem is the ranking is equal to 27% of the total count rows per subject."? What does total count refer to? This way we can better help you. Thank you for your time and efforts in advance.

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.