Swap Axis for Measure in Table

[former_member678452]

Hi Folks,

I would like to change the measure used in table, as per the example below, this works as expected.

Table.setDimensionFilter(Alias.MeasureDimension,"ELTUIDCMP5");

I would however like to swap the axis via script. Measures are currently set as 'columns' and I would like to change to 'rows'. How do I do this for a table widget?

Thanks

Patrick

[Bob0001 · Accepted solution]

Checkout addDimensionsToColumns and addDimensionsToRows and related methods on Table. You may refer to the measure dimension using Alias.MeasureDimension.

[former_member678452 · Accepted solution]

Thanks Bob,

It really was that simple!

Table.addDimensionToRows(Alias.MeasureDimension);

Cheers

Patrick