1 of 1 people found this helpful
I'm not clear on what you are trying to accomplish - can you provide something that outlines the expected results - as far as using a table calculation on - yes there are some things you can do - e.g. lookup() that First etc
this is just a simple example from superstore where sum(sales) > 1000 are High else Low
I added a look back 1 value and then a first() calculation so you can see it can be done
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.