I'm getting there as a newbie, but for some reason I can't work this one out:-
My first post after a cranial removal op ! so please excuse the methods.
I have a table where we download one table that shows transaction records (a bank account) with the usual fields:- date, amount, description etc which also has the field "Account #"
I need to make a separate unique list (portal/table) of the "Account #" references only eg, 12345-6789, 12345-9876 and so on to enable more filtering. I have a drop down list for searching the field "Account #" and everything else works fine, but I can't find a way to extract the unique "account #" values from the value list and display separate totals for the different account numbers (in a new layout/portal/tab).
FM 15 pro Advanced