How to Calculate YOY

    Hi ,

     

    I am trying to calculate YOY Value in a straight table.

     

    what i really required is when user selects Current Month of Fiscal year FY142014 Jun i.e  in YOY column i should get the value for FY2014 Jun-FY2013Jun value.for this i used Set Analysis . then i came to know set analysis will not work on row or column basis.

    for examaple as per below snapshot but if i take metric feild list and then list DA metric .. then YOY value is coming but with out any filters by defalut all values of YOU should come for all metrics . please help me how to do this.

    but if i take text object to check my Query its working . but same query its not working in my below table.

    =((

    Sum({$<QYM_MemberID_Label={'$(YOYLatest)'},Metric={"DA"}>}Missed)/Sum({$<QYM_MemberID_Label={'$(YOYLatest)'},Metric={"DA"}>}Cases))*100-
    (
    Sum({$<QYM_MemberID_Label={'$(YOYPrevious)'},Metric={"DA"}>}Missed)/Sum({$<QYM_MemberID_Label={'$(YOYPrevious)'},Metric={"DA"}>}Cases))*100)

    Thanks & Regards,

    Hari