How do I create new tables based upon a condition?

Anonymous 

I didn't understand the question very well, however, you can create a new table as follows

Table 1 = CALCULATETABLE ( ft, ft[SequenceScore] = 1 )

thanks Fowmy 
I try to get to a situation where I can use (e.g.) the Decoposition Tree Visualization to show the order in which consumers went through the events.
For this I need to provide seperate fields for the first event, the second event etc.

Your solution gives me the FT table per sequence, and I can use lookupvalue to add the eventname to the table but as soon as I try to create a relationship with the original FT table (to filter on data in other tables) it tells me that a circular dependency was detected. Any extra suggestions?

Your help is truly appreciated!