Looker: Strange Display or Formatting of Table Calculation in Visualisation

[ginandtobby]

Hi Community & Staff,

I have a pivot table with custom fields in explore, as shown in the screenshot below:

where:
Actual Job Value is my measure column, Cumsum is a custom field (table calculation).

Somehow in visualisation section it is showing all Cumsum columns together first, other than displaying it correctly like the data tab does (Cumsum custom field should tag after its measure column).

Please advise how to rectify this.

Many thanks!

[GavinW]

Are you able to see the measure columns at all?

[ginandtobby]

Hi Gavin,

Thank you for your reply. Yes, the measure columns were there but they were pushed behind. Please refer to the screenshot below:

Columns highlighted in red box are custom fields by table calculation. Columns highlighted in green box are measure columns. Thanks!