question on sorting dimensions with setDimensionFilter() in Table

[paumcl]

Hello,

I once again need your help:

I have a Story with various graphs and tables where I want to switch the dimensions. It is working fine with the graphs with this coding:

Chart_NWC_TABO_Ratio_Cons.removeMeasure("5WIFOPY8PE02JBZRPE1NYRFF8",Feed.ValueAxis);
Chart_NWC_TABO_Ratio_Cons.addMeasure("5WIFOPY8PE02JBZRPE1NYQDHW",Feed.ValueAxis);

 So now I try to do the same with tables, which is working:

Table_NWC_TABD_KPI_Cons.getDataSource().setDimensionFilter("5WIFOPY8PE02JBZRPE1NYQ76C",["5WIFOPY8PE02JBZRPE1NYQQ50","5WIFOPY8PE02JBZRPE1NYQJTG","5WIFOPY8PE02JBZRPE1NYQDHW"]);

I just have a big BUT: I am not capable of sorting the dimension the way I want it. The order should be the same as within the query (Total NetSales, NWC GC, NWC ratio). I do not find a way of changing the order. The technical names within the coding are also in the correct order.

Whatever I try, i always get this wrong order (no clue, where this even comes from):

Thanks and BR 

Clemens 

[jain06 · Accepted solution]

Hi,

Can u plz check this option and specify the order of measures

Thanks,

[paumcl · Accepted solution]

Hi, thanks for your reply. I honestly didn't think of this easy solution as I expected the table to take over the order of the structure of the query . I am confused, that the order is shown completely randomly. But ok... Thanks Clemens