The data fields "Month" and "Receipt Type" will be the dimension.
Under "Receipt Type" there are "Initial Receipt" and "Follow up Receipt" two different values. "Initial Receipt" value based on "Initial Receipt Date". "Follow up Receipt" based on "Follow up Receipt Date" . Such as,
Month Receipt Type Initial Receipt Date Follow up Receipt Date
Jan Initial Receipt 01/05/2015 01/08/2015
Feb Initial Receipt 02/05/2015
Mar Follow up Receipt 03/05/2015 03/08/2015
I would like to have the pivit table which can split two values from "Receipt Type" into two columns. Such as,
Follow up Receipt
How can I do with the Pivit table to create the one shows above? Am I able to do it?