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
This should do it
If(Num(Rank(TOTAL Only({<Name = {"=Sum(Amt1) + Sum(Amt2) > 0"}>}Name&Task), 4, 1)) = Count(DISTINCT TOTAL {<Name = {"=Sum(Amt1) + Sum(Amt2) > 0"}>} Name&Task), '*')
Is this what you are looking to get?
Name | Amt1 | Amt2 |
* | ||
BAB | 10 | 20 |
BCC | 7 | 9 |
CCC | 23 | 9 |
DDD | 100 | 200 |
Thanks
It should be like below
Name Amt1 Amt2 4thcolumn
BAB 10 20 *
BCC 7 9
CCC 23 9
DDD 100 200
Thanks
This?
Hi,
Thanks alot for earlier solution.
Can you please help me to understand how to make it work we introduce one more dimension in the table
PFA for more details
Thanks
Would you want to see 2 * or 1 * and where?
Thanks
BAB has Market and Sales and i want to see * on the first row ( just 1)
example first row
BAB Markets 10 20 *
This should do it
If(Num(Rank(TOTAL Only({<Name = {"=Sum(Amt1) + Sum(Amt2) > 0"}>}Name&Task), 4, 1)) = Count(DISTINCT TOTAL {<Name = {"=Sum(Amt1) + Sum(Amt2) > 0"}>} Name&Task), '*')
1 is not required, but 4 is used to give it distinct rank... that might not be needed as well because I added Task to the Only() function