Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can anyone please explain how to show the rank in text object. When i selected the name in the selection box then the Current Rank it should display in one Text Object and and previous rank in one more text object.
Below is the formula for ranking which is i used in Straight Table.
Thanks
KUMAR
No problem. I should say Many thanks to you. That's fine. Really got a great help from you.
for this below. I have given expression for Week. I need to show last 12 weeks but after selection its showing like this.
I need to last 12 weeks even there is no data.
In bar chart unchecked these options -> Suppress null values, Show all values and suppress zero values.
and its showing only odd numbers.
=Round((sum({< Datums=,WEEK1= {">=$(=MAX(WEEK1)-11)"}>} $(sumkm) )/sum({<Datums=,WEEK1= {">=$(=MAX(WEEK1)-11)"}>} [Kms Travelled])*1000))
after click on the Clear its showing last 12 weeks
no problem at all, I'm helping and getting help also 
for this one, I'll suggest you to create another specific thread because it is not related to the main problem of this thread.
when community members try to find solutions to their problems reading threads, they can be confused if they find a lot of different problems in one thread, so let's keep it the way it should be, one solved issue by thread easily findable by its name
so please copy and delete your last problem, paste it on a brand new thread with the right title and TAG ME
you're already in very good hands, sunny and the rest will get back to you 
but I'll take a look also
