Rotate mesh through material using World Position Offset

Can you please provide a little bit more details about how to properly combine these ones to achieve desired effect?