Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to create a user defined sorting. I have created 2 variables with name Vexpression and Vsorting. In Vexpression I have taken a variable input and in variable I have taken the Vexpression variable and in value sum(totalamount) and I have taken another variable input in that I have selected the variable Vsorting and in shows as drop down and in value for ascending (1) and for descending (-1) and I have taken a bar chart with dimension patientnumber and measure as sum(totalamount) in sorting I have disabled all the options and the dimensions which I used as patient number in that I have selected sort by expression and I have given expression as =$(Vexpression)*Vsorting but it is showing an error as garbage after expression Vsorting.
I tried to use $((Vexpression)*Vsorting) there is no error but my sorting option is not working
Please help me to solve this issue.
Thanks in advance 🙂
The call of $((Vexpression)*Vsorting) isn't valide. You may try it in this way: $(Vexpression) * $(Vsorting)
Thanks Marcus it's working 👍
The call of $((Vexpression)*Vsorting) isn't valide. You may try it in this way: $(Vexpression) * $(Vsorting)
Thanks Marcus it's working 👍