Pivot Table

Stimulsoft Reports.Net discussion
Post Reply
rafael.custodio
Posts: 15
Joined: Thu May 30, 2019 1:01 pm

Pivot Table

Post by rafael.custodio » Wed Jun 05, 2019 1:14 pm

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
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: Pivot Table

Post by Lech Kulikowski » Thu Jun 06, 2019 5:35 pm

Hello,

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

Thank you.
Post Reply