I have two workarounds, both of which has its shortage.
1. create a worksheet for prior week and current week, another for change, and then put them together in a dashboard.
shortage is that, it's difficult to deal with scroll bars if there too many rows.
2. something like the screenshot.
shortage is that, it is similar to, but doesn't look the same as what you expect, right?
Thanks for your effort Lee Chen.i already had given the above two solutions but client wants the same structure which i attached in the post.the solution is to have another value as 'Difference'in the dimension 'Record type'.but i don't know how to get it in the Tableau.is there any work around?please suggest me.
Sorry for my late reply!
The final way is to change the structure of your data source,
by using custom SQL or ETL tools or manual work.
The point is you should have a dimension contains "Prior Week", "Current Week", and "Change".
A example using csv union,
Create three csv files, "Prior Week.csv", "Current Week.csv", and "Change.csv",
each of them are with the same structure.
Unit Base Sales Base Incentive Total Sales Profit SM%
Then use union function like this
And you can easily (not real easy) get this,
Thank you very much for your help LEI,i have already tried with these techniques.wil be in touch with you in future.