Not to be confused with the ColumnNo

ColumnNo([total])

Returns the number of the current column within the current row segment in a pivot table. The first column is number 1. 

Column() will return the value in that column.

The count starts from 1 for the first expression. 

—

Column(ColumnNo)

Returns the value found in the column ColumnNo in a straight table or a pivot table.