I have a subset A which is a selection of the Global Customer List.
In my module which applies to the subset A, I'm trying to retrieve the Sales for the top level of the subset "total customers" (only the total of the selection of the customers from the global customer list). I tried [Select:'Subset A'.'total customers']. It is invalid.
I then changed it to [Select:'Global Customer'.'total customers'], it works. Unfortunately this is not the total customers number that I need.
It seems the Select function does not work with a subset? What would be the proper function to use then? Thank you!