Pivot on single measure field

  • 11 August 2017
  • 1 reply

We want to display a tabular view with single measure field (“budget revenue”) with a pivot dimension as (“Budget Name” -> ALL, APAC, NAR etc). As we see in the screenshot, the single measure field (“budget revenue”) is repeated for all values of the pivoted dimension column. Here the name “budget revenue” is too much repeated.

Instead we would like to display same tabular view but without duplicating the “budget revenue” in each column. (something like swapping the positions of measure field and pivot names, so that measure filed name is shown only once.).

Is there a way to achieve the same?

1 reply

Userlevel 4

@sujoybec51, that’s currently not possible, but you could hide the full field name on the visualisation through the edit menu. Have a look at the screenshot below.