My Report is fetching the marks obtained in a subject suppose there are 3 subjects :subject 1,subject 2 and subject 3;how will we get total of these three subjects from a RD?
You can use aggregate sum() function on the subject column to get the total of all the subjects.
@P.Siva.Praveen So the fx option available near the column source is that what you mean? Please find the attached screenshot. But there is no function available for aggregate sum().
In the summarize column there s count option. Please select that.
can you add one more column and mention column name as Total and in summarize column select count
PFA
@TanyaS58 we can have a nested add function to add the three values and label it as total.
please find the below snippet for reference.
@Ankush Agrawal thanku