Logic Required...................!!

[aveeeeeee7en]

Dear All

Below is the Snapshot of my Requirement:

Also, see the Attachments.

Regards

Av7eN

[aveeeeeee7en]

Anybody has the Answer for this........???

[petter · Accepted solution]

These expressions should do the trick in your second Chart:

Sum({<CommonYear={$(=max(CommonYear))},CommonMonth={"=$(=Max(CommonMonth))"}>}[Attrition Left])

Sum({<CommonYear={$(=max(CommonYear))},CommonMonth={"<=$(=Max(CommonMonth))"}>}[Attrition Left])

Sum({<CommonYear={$(=max(CommonYear))},CommonMonth={"=$(=Max(CommonMonth))"}>} ClosingMOB)

Sum({1<CommonYear={$(=Max(CommonYear))},CommonMonth={"<=$(=Max(CommonMonth))"}>} ClosingMOB ) / Max(CommonMonth)

((([Cumulative Attrition]/[Avg Closing MOB])*100)/Max(CommonMonth))*12

[petter]

[aveeeeeee7en]

Thank You Sir.

It's Logical.

Regards

Av7eN