Cross Table format

[Priyank Dwivedi]

Hi All,

I am trying to build a custom cross table as below but reaching dead end on how to configure it.

Base Data Table:

 

The resultant cross table that I would like to build :

 

Any ideas on how to go about it?

I can use 'Origin' column as the 'Horizontal Axis'.

'<Well NEST Date> as the Vertical Axis.

The challenging part is to know which forecast and gross columns belong to Oil Phase or Gas Phase! Any insights?

[Fredrik Rosell]

Hello,

Maybe you could simply transform your data into a format more suited for this, basically turning this wide data set with separate columns for each measurement into a "tall and skinny" dataset where you have all the measurements in a single column, and split Phase and Variables into separate columns.

To get there from the original data, I first added an Unpivot transformation to merge all four gross and forecast columns into a Category and Value column, and then binned the Category column to get the separate Phase and Variables columns, resulting in this format

 

[Priyank Dwivedi]

Oh superb! Thanks Fredrik...

I had never used the 'Binned Column' functionality. Super useful.

[Fredrik Rosell]

You're welcome, Priyank!