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 !!
Pivot Table
-
- Posts: 31
- Joined: Thu May 30, 2019 1:01 pm
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: Pivot Table
Hello,
You can use Grouping and Avg function.
https://www.stimulsoft.com/en/documenta ... groups.htm
Thank you.
You can use Grouping and Avg function.
https://www.stimulsoft.com/en/documenta ... groups.htm
Thank you.