Keep the percentage of YTD static

[Muralidhar]

Hi - I created a expression as shown below to get YTD percentage.

count (if([Completed on Time]='Yes',[Completed on Time]))/count([Completed on Time])

If I select a month, YTD percentage should not be changed (static). 

Any help is greatly appreciated.

Thank You

Muralidhar

[BrunPierre · Accepted solution]

Count({<Month=>}if([Completed on Time]='Yes',[Completed on Time]))/Count({<Month=>}[Completed on Time])

OR

Count({<[Completed on Time]={'Yes'},Month=>}[Completed on Time])/Count({<Month=>}[Completed on Time])

[Muralidhar]

Thanks much BrunPierre!