Quarter over Quarter Comparison

Hi guys!

I'm trying to prepare a pivot table that has the following columns: Amount Q1 and Amount Q2. The easiest and obvious way to do this is to set Period Date as one of the column filters.
The thing is, I DO NOT want to do this since I plan on adding calculated fields to ONLY ONE of the periods, and if i do it this way, if I make calculated fields, they will be added to both periods.

Can anyone give me a tip how to set this up?

(Note: the data I have is all in 1 column. There's a second column that says which Period it is)

Thank you,
Yosef

Hi,

How would you enter "Amount Q1" and "Amount Q2" in one column? Can you please post a sample template of your workbook (in excel format) using "Go Advanced" option? You may choose to delete the confidential data in the file before upload, if any.