I hope You are after This. and From your Data, I changed GRAPE to GRAPES so you are looking at 3 Strings not 4.
Pl Check Screenshot and attached
If it Helps, pl Mark it Helpful and CORRECT to close Thread.
Repeatation.twbx 16.8 KB
Not the question I was asking. I am looking for how often a string repeats.
Again the question is how do I get tableau to count the total number of string changes going down the column.
Think of a warehouse and if I get orders for apples I don't have to move anything around and I can keep packing apples. If I get an order for a different fruit I have to move things around. I am interested in how often I have to move things around.