Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have created a calculated dimension and ı wanna sort data according to this expression
my example
0-500 points
500-1000 points (these are results of dimension)
Thanks
hiiiii
in right click on your sheet object in properties--> sort tab there you check the numeric value asccending order
either you can sorting the value in script level.. for this you have load your table then the use group by function for sorting purpose
hope it helps
Go to sort tab,
Select ur caluculated dimension and use sort options based on requirement.
hi
sorting at script label:
order By name asc ;
or
object iproperties
sort tab --->check numeric value in asccending order
Thanks for replies ,
but it didnt work maybe if I give dimension
Could you give alternative solution?
=
if(Field>0 and Field<=500,'0-500 point,
if(Field>500 and Field_PUAN
<=1000,'500-1000 point, ))
Thanks
in dimension tab set your field as
=class(aggr(Sum(Field),Field_PAUN),vRange, 'n')
here vRange is variable that assigned to max value for one axis
like if yo want to display data with 2 values that set it to 500
or either in splitting form then set to 100
then range become 0<=n<100,100<=n<200..........1000
Thanks After I try , I will share ur solution is proper or not for my case:)