Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Am using expression in the sort tab to sort my items in dimension but not working. what do I do?
You have a parenthesis at the wrong spot, try this:
=Match([item text], 'Cupboards', 'Chairs', 'Building', 'PEE', 'Buriet', 'Isle', 'JV', 'Plastics', 'Desktop', 'System unit', 'Prints')
What is the expression that you are using? Is it not working after you make a selection or it just doesn't work?
It didn't work at all. I used =match(Field, ..,.,..,,.,..,)
It didn't work at all. I used =match(Field, ..,.,..,,.,..,)
What are those ..,..,..,? It would be helpful if you can post a sample or screenshot.
I used "MATCH" statement and its not working
I understand that your Match() expression isn't working. But without knowing further details, I cannot guide you because I have no idea what you are doing incorrectly. Unless you have more to provide, I won't be able to help. I hope someone else might be able to.
Best,
Sunny
Ok, I used if(match(Field, 'text','text'),Field) to pick specific items @ my dimension. Then wanna sort with =match(Field, 'text','text') to align what I actually want but not working.
Generally it would be like
=match(Dimensionname ,'5','B','A','1')
Try to change the value 5,B, A and 1 based on your need..
But, if you give your full expression in sort, we can help you..
I did, didn't work
Understood..that's why you posted. but how do we know why it is not working without more detail..
Could you please post a small amount of sample data?