ETL Pivot Tile

gbrown · May 2023

I am trying to pivot the warehouse clean column with the values to show like this:

How Would I go about formatting the pivot tile for this?

Thanks

MarkSnodgrass · May 2023

In the Pivot Tile, you will want to put Warehouse Clean in field 1 (Select the column that has the column labels you want).

In Field 2, select your StockCode column.

In Field 3, type Buford OnHand

In Field 4, type Buford

In Field 5, select the OnHand column.

To add the Bufor OnSO, click Add Column and fill out fields 3,4, and 5 with this.

In Field 3, type Buford OnSO

In Field 4, type Buford

In Field 5, select the OnSO column.

You would need to repeatedly click Add Columns if you wanted to add your other warehouses and fill it out like I outlined for Buford.

MarkSnodgrass · May 2023

In the Pivot Tile, you will want to put Warehouse Clean in field 1 (Select the column that has the column labels you want).

In Field 2, select your StockCode column.

In Field 3, type Buford OnHand

In Field 4, type Buford

In Field 5, select the OnHand column.

To add the Bufor OnSO, click Add Column and fill out fields 3,4, and 5 with this.

In Field 3, type Buford OnSO

In Field 4, type Buford

In Field 5, select the OnSO column.

You would need to repeatedly click Add Columns if you wanted to add your other warehouses and fill it out like I outlined for Buford.

Best Answer