Why not upload a sample file, to help in your query ? It sounds as if you are not clicking in the pivot field before going to the calculated field option.( you can click in any field) Also if you upload an example, put in your expected results, calculation etc