I am sure there are simpler ways to do this, but can you see if the attached twbx workbook wil work for you.
What I have done is:
1. Add a quarter Begin Date field to your data source.
2. Create a Previous quarter calculated field
3. Duplicate your data source and blend it with the original , joining the Previous Quarter field in the original data source to the Quarter Start Date field in the duplicate and join on the product field as well.
4. Now you will be able to get the Curent quarter sale and the previous quarter sale in a single row.
I am not able to open your workbook.
I have Tableau desktop 9.0
Is there any chance to resent with lower or equivalent version one please
Here is my solution without duplicating data source.
Added 3 lookup()-based table calculations. Make them compute using Quarter Start Date.
Open the workbook using Tableau Public or Tab 9.1.
Is there any chance to to send it in version 9.0 please