Hello,
This is a sample of data:
Thee are the available values for year and period:
nd these are the desired results:
This can be accomplished by creating a matrix with the following options:
Rows = Type
Columns Year & Period
Values: sum(#)
I need to add a column (diff) that shows the difference between each individual column and the previous column (and the difference between totals as well).
Thank you for your help.
This is a sample of data:
Thee are the available values for year and period:
nd these are the desired results:
This can be accomplished by creating a matrix with the following options:
Rows = Type
Columns Year & Period
Values: sum(#)
I need to add a column (diff) that shows the difference between each individual column and the previous column (and the difference between totals as well).
Thank you for your help.