GroupBy with multiple fields

[stoffman]

Hi,

How can do multiple group-by consolidation? As mentions in the docs that can be done, But I didn't find a way. For example suppose I wish to group by by both "Country" and "City":

Code: Select all

  S:= TSummary.Create(nil);
  S.AddGroupBy(Data['Country']);
  S.AddGroupBy(Data['City']);
  S.AddMeasure( Data['City'], TAggregate.Count );

I get the following error:
"Unkown field type: Count of City"

Just doing

Code: Select all

  S.AddGroupBy(Data['City']);
  S.AddMeasure( Data['City'], TAggregate.Count );

Works great.

What am I doing wrong?

Thanks,

[Yeray]

Hello,

Have you seen the Visualizer demo at "Demos\VCL\Visualizer"?