You want to be as close to the pivot point as possible to feel the least movement. Avoid cabins near the front (bow) or back (stern) and on decks higher than the middle deck of the ship. So, on a ship with fourteen passenger decks, your best options are below deck seven.
Is it better to be near the front or back of a cruise ship?
If you suffer from motion sickness, or are a first-time cruiser and want to play it safe; it is not recommended you sail in a stateroom in the forward section of the ship. The most desirable location is a mid-ship stateroom, or if not available, a stateroom towards the back (aft) of the ship.