Good afternoon all,
I have a data set that i would like to reformat (attached). I would like to replicate the pivot table in sheet 2 by making row data column data.
Any help would be greatly appreciated.
Many thanks.
David.
Solved! Go to Solution.
Hi David,
Thank you. I also wanted the Cost Centre along the top too. Is this possible?
David.
The way I created the columns is to add the fields together that you want included, so to include Cost Center, the [Column] field before the CrossTab becomes:
tostring([Cost Center])+'_'+tostring([Year])+'_'+padleft(tostring([Month]),2,'0')
Padleft is used to make sure the months appear in the right order.
Perfect, thanks very much. Handy formula there!