Pivot Table

[rafael.custodio]

Hi, I have a very simple report and I would like to generate something like a Pivot Table for it.
My report goes as the example :

Student...................Grade
Aluno1......................10
Aluno1.......................8
Aluno1.......................7
Aluno1.......................8
Aluno1.......................6
Aluno2.......................9
Aluno2.......................8
Aluno2.......................9
Aluno2......................10
Aluno2.......................7

I would like to have my report showing only one row for each student and the average grade for each one in something like this:

Student....................Grade Avg
Aluno1.........................7.8
Aluno2.........................8.6

Thanks in advance !!

[Lech Kulikowski]

Hello,

You can use Grouping and Avg function.
https://www.stimulsoft.com/en/documenta ... groups.htm

Thank you.