I am trying to filter a repeating Table so that it only shows unique values. I currently have a setup as such myFields/Group7/Group8/Field11. Field 11 get's it's values from a cascading listbox. I want only the unique values to be displayed. I've tried using filters similar to http://www.infopathdev.com/blogs/greg/archive/2005/06/08/Display-Only-Unique-Options-in-a-List.aspx and http://www.infopathdev.com/forums/p/6773/24839.aspx. Nothing has been working fo me. I figured something along the lines of not(my:group8/my:field11 = ../preceding::my:group8/myfield2) would at least do something even if it wasn't what I wanted it to do. My repeating table doesn't even recognize that there is a filter. Any suggestions?
Figured out a solution. It is a roundabout way but I got it to work using a bunch of conditional formatting.