ordenate all values but four in a table

[#1]

Hello.

I have a straight table, ordened by number in the second column, but I need that four expecifical values be displayed at the end in a concret position.

Can I do this?

Regards

[christophebrault · Accepted solution]

Hi,

Yes you can do this with a little trick .

Order with your dimension first and check expression. use your expression in this case to order the chart but add an if statement :

if(ID='1' or ID='12' or ID='13',0,sum(VALUE))

In my exemple, ID is my dimension and VALUE my fact.

This expressions used to order the table will affect 0 to IDs I've add to the if.

See the attached file for démo

[#3]

It works!!!

Thanks a lot