Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
It works!!!
Thanks a lot