This content has been marked as final. Show 4 replies
Pivot table can be used to show in desired format:
In Dimensions: X and Calendar Year
In Sort - make sure X is first dimension.
This will give you a pivot table in format piv1 per attached.
Click on + to display Calendar Year (piv 1a)