Summary Field from External Datasource

[ejpvi]

I am including a read only Table Occurrence from my SQL table.

I am trying to figure out a way to run summary calculations, and sub-summary calculations, and aggregate functions on several values from those external tables... but I cannot add variables to that table, and I can't figure out how to make it work.

Is there something I am missing. Has any created summary fields from external tables?