sends command to server for createPivot