How do I add a totals / averages row to a crosstab row group?
LegionDev
I have a crosstab that works out the average for the pivoted column.
It looks like this 
I need to have averages totals for "Part Mark", "Exam Mark" and "Mod Mark" like the pivoted columns have
Here is what the report in iReport looks like (I've added green blocks with my amazing photo editing skills to show where the totals fields will need to be)
LegionDev
Here is the Solution:
- create measure which should represent the field for which you want to perform the Average calculation
- set Value Expression to the field on which Average calculation should be performed
- set Calculation to Average
- add this field to the Total section of your crosstab
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Not able to get the score logs for all possible solution using optaplanner in grails app
- Next: Browser Zoom at 100%, not showing actual image pixel ratio
Related
Related Related
- 1
Add a summary row with totals
- 2
How do I group by and "prefer" a row
- 3
Pandas: add crosstab totals
- 4
How can I use VBA to add a totals row at the end of new table
- 5
pandas: how do I select first row in each GROUP BY group?
- 6
how can I summarize different columns to make totals by row?
- 7
how can I summarize different columns to make totals by row?
- 8
how do i group rows by an id row in group_concat into one row string?
- 9
How do I update a single row in each group?
- 10
How do I remove the arrow for a particular group (row) in an ExpandableListView
- 11
How do i get max salary row , group by country
- 12
how do i use group by in only one row?
- 13
How do I select a row with max count doing a group by
- 14
Entity Framework 6: Add a summary row with totals
- 15
How do I add a column to Kendo Grid that is editable when you add a row but not when you edit a row?
- 16
How do I subtract the previous row from the current row within a group in Hive?
- 17
How do I (efficiently) add a vector to every row of a matrix in Julia?
- 18
How do I add an persistent column of row ids to Spark DataFrame?
- 19
How do I add a row to a Datagrid in C# WPF
- 20
How do I add a row to a 2D array?
- 21
How do I add a footer row in a WPF datagrid?
- 22
How do I add button on each row in datatable?
- 23
How do I add row programatically in TDBGrid in Delphi
- 24
How do I add an clicklistener to a row in table Layout
- 25
How do I add one row of a PANDAS dataframe to the rest of the rows?
- 26
How do I add a dropdown button on each row of a jquery datatable
- 27
How do I add a row of data to specific columns?
- 28
How do I add a new row of data to a CSV file with Python?
- 29
How do i add one row with button with "document.createTextNode"
Comments