Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have a requirement ,how can we use rank function to sort the column in straight table alphabetically A to Z( but suppressing where expressions amounts are 0 and null) and have a "* "in just first row?
PFA which explains the requirement clearly.
Thanks
Thanks for helping me understand.
Is it possible to make * sign always stays for first row? ( BAB - Market)
Like when we select BCC - Market row or CCC - Sales or DDD - Sales the * should go away from the table, it should always stays on BAB - Market?
Thanks
Why not create it in the script and how did you decide it to be BAB - Market? Can this change based on the new data that comes in?
Hi,
Yes it can change, * sign should always be on the first row,
like if i get BAA - Market with some AMt values then * should always stay on that row instead of BAB - Market
Thanks
But the first row can change based on selection, no? if it is first row based on overall data... I would still say do it in script