Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
Below is the Snapshot of my Requirement:
Also, see the Attachments.
Regards
Av7eN
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
Anybody has the Answer for this........???
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
Thank You Sir.
It's Logical.
Regards
Av7eN