Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
i've got a simple table like below where i've stored a list of numbers.
Tab1:
Number |
---|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
I want to create one new field in order to use as filter where if i select:
How to achieve this by using an elegant solution ? Maybe hierarchy() function could be the correct way but i didn't understand how to write the code...
Thanks
The same logic works but you may like to have ID field in case real data is bit more complex.
Hi,
you can try this:
pick(match(-1,Number>=1 and Number<=5,Number>5 and Number<=9), 'All numbers equal minors of 5','All numbers equal minors of 9') as label
PFA
Not an elegant one but simple solution specific to your sample problem, not sure if actual data is complex then this -
How can i do the same things if my Tab1 contains text and not numbers ?
Es:
Tab1:
Header 1 |
---|
Group A |
Group B |
Group C |
Group D |
Group E |
Group F |
Group G |
Group H |
Group I |
So:
The same logic works but you may like to have ID field in case real data is bit more complex.