conditions and limits above a view are too broadly allowed to be pushed through a view layer containing window functions.
From the forum posting for example:
returns the correct counts, where as
returns counts where the state province id condition is applied before the windowing.
The currently logic will only prevent the criteria from being pushed if it is directly applied against a computed window value.