Extract a list with details

Hello,

I’m stuck on a trade and can’t go on!

In the “statistics” table I’ve several columns (ID, YEAR, and all virtual columns) where it marks me the registered customers, expiring etc …

I would like to insert a VC for view the list of services sold (table “services”) concatenated with the number of the count (table “memo”).

Is there a specific function to concatenate all of this?

Now, I’m creating individual VC with the service name and counting formula, but when I enter other services, I will have to add another VC manually.

Thanks in advance and forgive the translation.

In the photo there are the virtual columns that I created.

is it possible to enclose everything in a single expression?

With the automatic insertion of the new added service

There is no way to automatically create new virtual columns.

3 Likes