Find out average on Matrix report RRS feed

  • Question

  • User-543160537 posted


     I am trying to develop matrix report in below format, But I need to find the average of rating and yes/no options columns wise and rows wise.

    For ex: I need to know form rating at the bottom of the row and "ADB" column rating and yes/no at that column end with Average of rating and Y/N.

    FORM Average Rating YES/NO FORM 2 Average Rating YES/NO AvG Rating  MIN CHECKBOX   SELECTED max(Y/N)
    ABC ADB x 2 y x 5 y 3.5 A Y
    WER x 3 N x 4 N 3.5 B Y
    QWE     N     N   C N
    CVB x 1 Y x 3 Y 2 C Y
    POI x 1 N x 1 N 1 C N
    MKI     Y     Y      
    OIU x 4 Y x 4 Y 4 D Y
    GYT x 2 Y x 2 Y 2 D Y
    Avg(Rating) = 2.16 Max(Y/N) Avg(Rating) = 3.16 Max(Y/N)

    can some please help me how to generate report is SSRS.



    Sunday, July 5, 2015 12:13 PM