sort

[Anonymous]

Hi Experts,

I have one straight table  with

dim: add calculated dimension

expression is :

sum(value)

count(number)

sum(cost)

count(distinct id)

when I do sorting , it is not happening      but if I  disable the   4th expression sorting is working   why?

any reason behind this

here my dimension and   id are from 2 different tables .

but there is a association with different fields /

[Anil_Babu_Samineni]

Sort is not working? What was that sorts keys

Can we know those result expecting by screen shots

[jonathandienst]

I have seen a problem before withe sorting not working with a "distinct"...

[Anonymous · Accepted solution]

Hi Folks ,

I got the solution

rowno() function has been used in background color expression,  which is not allowing for sort

commented that code tested ,its working now

Thanks all