cancel
Showing results for 
Search instead for 
Did you mean: 

question on sorting dimensions with setDimensionFilter() in Table

paumcl
Explorer
0 Kudos
136

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):

paumcl_0-1718964261595.png

Thanks and BR 

Clemens 

Accepted Solutions (1)

Accepted Solutions (1)

jain06
Explorer
0 Kudos

Hi,

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

Thanks,

jain06_0-1719201263587.png

 

paumcl
Explorer
0 Kudos
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

Answers (0)