I need to create a value list for portal filtering. The data in the portal is of the format:
As you can see, there are multiple customers on the data table, so if I create a value list based on the values in 'Year', it'll be massive as it's picking up each record. Instead I just want the value list to look at each distinct instance for the customer who's record I'm viewing at the moment (and therefore it's only their records in the portal) and return, in this case above, only 3 year's worth:
I've tried an ExecuteSQL Select Distinct and this is waaaaay slow, so it's not viable in my case.
Any other help though is greatly appreciated.
Thanks in advance