GroupBy with multiple fields

TeeBI VCL
1

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”:

  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

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

Works great.

What am I doing wrong?

Thanks,

2

Hello,

Have you seen the Visualizer demo at “Demos\VCL\Visualizer”?