In Jaspersoft studio 6, How to calculate total for a particular row in crosstab

I am using in Jaspersoft studio 6 and currently working with crosstab. I am a newbie in crosstab and have just started using it. I have created a jrxml file with crosstab(with lots of trial and error, I might add) as follows

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0  -->
<!-- 2022-06-29T11:26:23 -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="MAH_Attendance_subjasper" pageWidth="1500" pageHeight="650" orientation="Landscape" columnWidth="1460" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0e151e12-e64e-4195-aba5-d1747d8a798d">
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MAH HR DB"/>
    <property name="com.jaspersoft.studio.unit." value="pixel"/>
    <style name="Crosstab_CH" mode="Opaque"/>
    <style name="Crosstab_CG" mode="Opaque" backcolor="#BFE1FF">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Crosstab_CT" mode="Opaque" backcolor="#005FB3">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="Crosstab_CD" mode="Opaque" backcolor="#FFFFFF">
        <box>
            <pen lineWidth="0.5" lineColor="#000000"/>
            <topPen lineWidth="0.5" lineColor="#000000"/>
            <leftPen lineWidth="0.5" lineColor="#000000"/>
            <bottomPen lineWidth="0.5" lineColor="#000000"/>
            <rightPen lineWidth="0.5" lineColor="#000000"/>
        </box>
    </style>
    <style name="CS_Sunday" backcolor="#FFFFFF">
        <conditionalStyle>
            <conditionExpression><![CDATA[$V{DayOfWeeek}=="SUN"]]></conditionExpression>
            <style forecolor="#058FFF" backcolor="#737373"/>
        </conditionalStyle>
    </style>
    <queryString language="SQL">
        <![CDATA[SELECT 
    emp.emp_number AS empNumber,
    CONCAT_WS(" ",emp.first_name,emp.middle_name,emp.last_name)AS emp_name,
    att.punch_in_time AS PunchInTime,
    att.punch_out_time AS PunchOutTime,
    TIME_FORMAT(TIMEDIFF(CONCAT(DATE(att.punch_out_date)," ",(att.punch_out_time)),CONCAT(DATE(att.punch_in_date)," ",(att.punch_in_time))),'%H:%i') AS Total,
    att.shift_in_time AS Rosterin,
    att.shift_out_time AS Rosterout,
    TIME_FORMAT(TIMEDIFF(att.punch_out_time,att.shift_out_time),'%H:%i') AS Extra,
    IFNULL(DATE(att.punch_in_date),'') AS punch_in_date,
    DAYOFMONTH(att.punch_in_date) AS DayOfMonthh,
    CASE
        WHEN DAYOFWEEK(att.punch_in_date)=1 THEN 'SUN'
        WHEN DAYOFWEEK(att.punch_in_date)=2 THEN 'MON'
        WHEN DAYOFWEEK(att.punch_in_date)=3 THEN 'TUE'
        WHEN DAYOFWEEK(att.punch_in_date)=4 THEN 'WED'
        WHEN DAYOFWEEK(att.punch_in_date)=5 THEN 'THU'
        WHEN DAYOFWEEK(att.punch_in_date)=6 THEN 'FRI'
        WHEN DAYOFWEEK(att.punch_in_date)=7 THEN 'SAT'
    END AS DayOfWeeek
    
    
FROM
    hr_employees emp, 
    hr_pay_periods hpr,
    hr_setup SETUP1,
    hr_setup SETUP2,
    hr_transfers tr,
    hr_emp_attendance att 
        LEFT JOIN hr_leaves lv ON (att.employee_id=lv.employee_id AND att.punch_in_date BETWEEN lv.start_date AND lv.end_date) 
    LEFT JOIN hr_leave_types lt ON(lt.id = lv.leave_type_id AND lt.leave_division_code="LOP")
    
WHERE 
        
    emp.id =att.employee_id
    AND emp.id =tr.employee_id
    AND emp.emp_number=1
    AND tr.active_yn='1' 
    AND DATE_FORMAT(tr.start_date,'%Y-%m-%d')<=DATE_FORMAT(hpr.end_date,'%Y-%m-%d')
    AND (DATE_FORMAT(tr.end_date,'%Y-%m-%d')>=DATE_FORMAT(hpr.start_date,'%Y-%m-%d') OR tr.end_date IS NULL) 
    AND DATE_FORMAT(att.punch_in_date,'%Y-%m-%d') >=DATE_FORMAT(hpr.start_date,'%Y-%m-%d')
    AND DATE_FORMAT(att.punch_in_date,'%Y-%m-%d') <=DATE_FORMAT(hpr.end_date,'%Y-%m-%d')
    AND DATE_FORMAT(att.punch_in_date,'%Y-%m-%d') >=DATE_FORMAT(tr.start_date,'%Y-%m-%d')
    AND (DATE_FORMAT(att.punch_in_date,'%Y-%m-%d')<=DATE_FORMAT(tr.end_date,'%Y-%m-%d') OR tr.end_date IS NULL) 
    AND SETUP1.setup_key="HR_EMPLOYEE_NUM_PREFIX" 
    AND SETUP2.setup_key="HR_EMPLOYEE_NUM_SUFFIX"  
   AND att.punch_in_date BETWEEN '2022-03-01' AND '2022-03-31'
    ORDER BY emp.emp_number,punch_in_date]]>
    </queryString>
    <field name="empNumber" class="java.lang.String"/>
    <field name="emp_name" class="java.lang.String"/>
    <field name="PunchInTime" class="java.sql.Time"/>
    <field name="PunchOutTime" class="java.sql.Time"/>
    <field name="Total" class="java.sql.Time"/>
    <field name="Rosterin" class="java.sql.Time"/>
    <field name="Rosterout" class="java.sql.Time"/>
    <field name="Extra" class="java.sql.Time"/>
    <field name="punch_in_date" class="java.lang.Object"/>
    <field name="DayOfMonthh" class="java.lang.Integer"/>
    <field name="DayOfWeeek" class="java.lang.String"/>
    <background>
        <band splitType="Stretch"/>
    </background>
    <summary>
        <band height="161" splitType="Stretch">
            <property name="com.jaspersoft.studio.unit.height" value="px"/>
            <crosstab ignoreWidth="false">
                <reportElement x="0" y="0" width="1300" height="160" uuid="b9ff42cf-4d41-4581-93ba-9a6a0d737d58">
                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                    <property name="com.jaspersoft.studio.crosstab.style.header" value="Crosstab_CH"/>
                    <property name="com.jaspersoft.studio.crosstab.style.group" value="Crosstab_CG"/>
                    <property name="com.jaspersoft.studio.crosstab.style.total" value="Crosstab_CT"/>
                    <property name="com.jaspersoft.studio.crosstab.style.detail" value="Crosstab_CD"/>
                    <property name="com.jaspersoft.studio.unit.width" value="px"/>
                    <property name="com.jaspersoft.studio.unit.height" value="px"/>
                </reportElement>
                <box>
                    <pen lineWidth="1.0" lineStyle="Solid"/>
                </box>
                <crosstabHeaderCell>
                    <cellContents>
                        <textField pattern="" isBlankWhenNull="false">
                            <reportElement key="textField-1" mode="Transparent" x="0" y="0" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="5cb94b6f-b1c1-4751-8cc9-1023a08817ba"/>
                            <box>
                                <pen lineWidth="1.0" lineStyle="Solid"/>
                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                            </box>
                            <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None">
                                <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
                                <paragraph lineSpacing="Single"/>
                            </textElement>
                            <textFieldExpression><![CDATA["Date"]]></textFieldExpression>
                        </textField>
                        <textField pattern="" isBlankWhenNull="false">
                            <reportElement key="textField-1" style="CS_Sunday" mode="Transparent" x="0" y="20" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="acfafcf8-f527-474d-8627-a7132a747c48"/>
                            <box>
                                <pen lineWidth="1.0" lineStyle="Solid"/>
                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                            </box>
                            <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None">
                                <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
                                <paragraph lineSpacing="Single"/>
                            </textElement>
                            <textFieldExpression><![CDATA["Day"]]></textFieldExpression>
                        </textField>
                    </cellContents>
                </crosstabHeaderCell>
                <rowGroup name="empNumber" width="60" mergeHeaderCells="false">
                    <bucket class="java.lang.String">
                        <bucketExpression><![CDATA[$F{empNumber}]]></bucketExpression>
                    </bucket>
                    <crosstabRowHeader>
                        <cellContents mode="Opaque" style="Crosstab_CH">
                            <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                            <property name="com.jaspersoft.studio.unit.height" value="px"/>
                            <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
                            <textField pattern="" isBlankWhenNull="false">
                                <reportElement key="textField-1" mode="Transparent" x="0" y="0" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="46855b10-d1a0-4975-b4a9-0c4e63fc8004"/>
                                <box>
                                    <pen lineWidth="1.0" lineStyle="Solid"/>
                                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None">
                                    <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
                                    <paragraph lineSpacing="Single"/>
                                </textElement>
                                <textFieldExpression><![CDATA["In"]]></textFieldExpression>
                            </textField>
                            <textField pattern="" isBlankWhenNull="false">
                                <reportElement key="textField-1" mode="Transparent" x="0" y="20" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="61085207-f106-4ae5-a7be-a40dd4f9e33b"/>
                                <box>
                                    <pen lineWidth="1.0" lineStyle="Solid"/>
                                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None">
                                    <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
                                    <paragraph lineSpacing="Single"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Out"]]></textFieldExpression>
                            </textField>
                            <textField pattern="" isBlankWhenNull="false">
                                <reportElement key="textField-1" mode="Transparent" x="0" y="40" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="577e468c-f2a4-4e42-99f1-287363338475"/>
                                <box>
                                    <pen lineWidth="1.0" lineStyle="Solid"/>
                                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None">
                                    <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
                                    <paragraph lineSpacing="Single"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Total"]]></textFieldExpression>
                            </textField>
                            <textField pattern="" isBlankWhenNull="false">
                                <reportElement key="textField-1" mode="Transparent" x="0" y="60" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="d89eaa0d-ddd9-4352-9fbb-46572e082ed5"/>
                                <box>
                                    <pen lineWidth="1.0" lineStyle="Solid"/>
                                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None">
                                    <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
                                    <paragraph lineSpacing="Single"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Roster In"]]></textFieldExpression>
                            </textField>
                            <textField pattern="" isBlankWhenNull="false">
                                <reportElement key="textField-1" mode="Transparent" x="0" y="80" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="1e60e74b-1df1-4a2b-8ba4-e639b7c95a47"/>
                                <box>
                                    <pen lineWidth="1.0" lineStyle="Solid"/>
                                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None">
                                    <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
                                    <paragraph lineSpacing="Single"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Roster Out"]]></textFieldExpression>
                            </textField>
                            <textField pattern="" isBlankWhenNull="false">
                                <reportElement key="textField-1" mode="Transparent" x="0" y="100" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="c9cb35b1-69d9-4075-8a74-2b6e3a5d4916">
                                    <property name="com.jaspersoft.studio.unit.height" value="pixel"/>
                                </reportElement>
                                <box>
                                    <pen lineWidth="1.0" lineStyle="Solid"/>
                                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                </box>
                                <textElement textAlignment="Center" verticalAlignment="Middle" rotation="None">
                                    <font fontName="Arial" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
                                    <paragraph lineSpacing="Single"/>
                                </textElement>
                                <textFieldExpression><![CDATA["Extra"]]></textFieldExpression>
                            </textField>
                        </cellContents>
                    </crosstabRowHeader>
                    <crosstabTotalRowHeader>
                        <cellContents mode="Opaque" style="Crosstab_CT">
                            <staticText>
                                <reportElement x="0" y="0" width="0" height="0" forecolor="#FFFFFF" uuid="6b02ffab-4f0f-4c9b-ab2c-46ca85f651a3"/>
                                <text><![CDATA[Total empNumber]]></text>
                            </staticText>
                        </cellContents>
                    </crosstabTotalRowHeader>
                </rowGroup>
                <columnGroup name="DayOfMonthh" height="20">
                    <bucket class="java.lang.Integer">
                        <bucketExpression><![CDATA[$F{DayOfMonthh}]]></bucketExpression>
                    </bucket>
                    <crosstabColumnHeader>
                        <cellContents mode="Opaque" style="Crosstab_CH">
                            <textField>
                                <reportElement style="CS_Sunday" x="0" y="0" width="40" height="20" uuid="718bc55d-1ed4-460e-80dd-af8703ba0c90">
                                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
                                </reportElement>
                                <box>
                                    <pen lineWidth="1.0" lineStyle="Solid"/>
                                </box>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                    <font isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$V{DayOfMonthh}]]></textFieldExpression>
                            </textField>
                        </cellContents>
                    </crosstabColumnHeader>
                    <crosstabTotalColumnHeader>
                        <cellContents mode="Opaque" style="Crosstab_CT">
                            <staticText>
                                <reportElement x="0" y="0" width="0" height="0" forecolor="#FFFFFF" uuid="07e7807e-6981-4dab-b854-c5c8bf274b97"/>
                                <text><![CDATA[Total DayOfMonthh]]></text>
                            </staticText>
                        </cellContents>
                    </crosstabTotalColumnHeader>
                </columnGroup>
                <columnGroup name="DayOfWeeek" height="20">
                    <bucket class="java.lang.String">
                        <bucketExpression><![CDATA[$F{DayOfWeeek}]]></bucketExpression>
                    </bucket>
                    <crosstabColumnHeader>
                        <cellContents mode="Opaque" style="CS_Sunday">
                            <textField isBlankWhenNull="true">
                                <reportElement style="CS_Sunday" x="0" y="0" width="40" height="20" uuid="23a405f5-a6c2-4f4a-be59-d9d5a9e16f3f"/>
                                <box>
                                    <pen lineWidth="1.0" lineStyle="Solid"/>
                                </box>
                                <textElement textAlignment="Center" verticalAlignment="Middle">
                                    <font isBold="true"/>
                                </textElement>
                                <textFieldExpression><![CDATA[$V{DayOfWeeek}]]></textFieldExpression>
                            </textField>
                        </cellContents>
                    </crosstabColumnHeader>
                    <crosstabTotalColumnHeader>
                        <cellContents mode="Opaque" style="Crosstab_CG">
                            <staticText>
                                <reportElement x="0" y="0" width="40" height="20" uuid="edcbd158-c0e7-4268-aff9-0e302e553b25"/>
                                <text><![CDATA[Total DayOfWeeek]]></text>
                            </staticText>
                        </cellContents>
                    </crosstabTotalColumnHeader>
                </columnGroup>
                <measure name="PunchInTime_MEASURE" class="java.sql.Time" calculation="Count">
                    <measureExpression><![CDATA[$F{PunchInTime}]]></measureExpression>
                </measure>
                <measure name="PunchOutTime_MEASURE" class="java.sql.Time" calculation="Count">
                    <measureExpression><![CDATA[$F{PunchOutTime}]]></measureExpression>
                </measure>
                <measure name="Total_MEASURE" class="java.sql.Time">
                    <measureExpression><![CDATA[$F{Total}]]></measureExpression>
                </measure>
                <measure name="Rosterin_MEASURE" class="java.sql.Time" calculation="Count">
                    <measureExpression><![CDATA[$F{Rosterin}]]></measureExpression>
                </measure>
                <measure name="Rosterout_MEASURE" class="java.sql.Time" calculation="Count">
                    <measureExpression><![CDATA[$F{Rosterout}]]></measureExpression>
                </measure>
                <measure name="Extra_MEASURE" class="java.sql.Time" calculation="Count">
                    <measureExpression><![CDATA[$F{Extra}]]></measureExpression>
                </measure>
                <crosstabCell width="40" height="120">
                    <cellContents mode="Opaque" style="Crosstab_CD">
                        <property name="com.jaspersoft.studio.unit.width" value="px"/>
                        <textField pattern="HH:mm" isBlankWhenNull="true">
                            <reportElement style="CS_Sunday" x="0" y="0" width="40" height="20" uuid="4b55089e-2a5c-4ce4-beea-3bb57815c61b"/>
                            <box>
                                <pen lineWidth="1.0" lineStyle="Solid"/>
                            </box>
                            <textElement textAlignment="Center" verticalAlignment="Middle"/>
                            <textFieldExpression><![CDATA[$V{PunchInTime_MEASURE}]]></textFieldExpression>
                        </textField>
                        <textField pattern="HH:mm" isBlankWhenNull="true">
                            <reportElement style="CS_Sunday" x="0" y="20" width="40" height="20" uuid="bd55a1cc-0094-482b-b3ff-35197f893d52"/>
                            <box>
                                <pen lineWidth="1.0" lineStyle="Solid"/>
                            </box>
                            <textElement textAlignment="Center" verticalAlignment="Middle"/>
                            <textFieldExpression><![CDATA[$V{PunchOutTime_MEASURE}]]></textFieldExpression>
                        </textField>
                        <textField pattern="HH:mm" isBlankWhenNull="true">
                            <reportElement style="CS_Sunday" x="0" y="40" width="40" height="20" uuid="6a7f1df0-e5df-42f1-8ca7-df0d2baa4ee5"/>
                            <box>
                                <pen lineWidth="1.0" lineStyle="Solid"/>
                            </box>
                            <textElement textAlignment="Center" verticalAlignment="Middle"/>
                            <textFieldExpression><![CDATA[$V{Total_MEASURE}]]></textFieldExpression>
                        </textField>
                        <textField pattern="HH:mm" isBlankWhenNull="true">
                            <reportElement style="CS_Sunday" x="0" y="60" width="40" height="20" uuid="84b3700f-d3e9-4401-be4e-db1b6c6ea42e"/>
                            <box>
                                <pen lineWidth="1.0" lineStyle="Solid"/>
                            </box>
                            <textElement textAlignment="Center" verticalAlignment="Middle"/>
                            <textFieldExpression><![CDATA[$V{Rosterin_MEASURE}]]></textFieldExpression>
                        </textField>
                        <textField pattern="HH:mm" isBlankWhenNull="true">
                            <reportElement style="CS_Sunday" x="0" y="80" width="40" height="20" uuid="d118ce37-b5d5-4082-8244-31941463812b"/>
                            <box>
                                <pen lineWidth="1.0" lineStyle="Solid"/>
                            </box>
                            <textElement textAlignment="Center" verticalAlignment="Middle"/>
                            <textFieldExpression><![CDATA[$V{Rosterout_MEASURE}]]></textFieldExpression>
                        </textField>
                        <textField pattern="HH:mm" isBlankWhenNull="true">
                            <reportElement style="CS_Sunday" x="0" y="100" width="40" height="20" uuid="f79896f4-39d6-4de6-8c6f-1ec067bd503e"/>
                            <box>
                                <pen lineWidth="1.0" lineStyle="Solid"/>
                            </box>
                            <textElement textAlignment="Center" verticalAlignment="Middle"/>
                            <textFieldExpression><![CDATA[$V{Extra_MEASURE}]]></textFieldExpression>
                        </textField>
                    </cellContents>
                </crosstabCell>
                <crosstabCell height="120" columnTotalGroup="DayOfMonthh">
                    <cellContents/>
                </crosstabCell>
                <crosstabCell width="60" height="20" rowTotalGroup="empNumber" columnTotalGroup="DayOfMonthh">
                    <cellContents/>
                </crosstabCell>
                <crosstabCell height="120" columnTotalGroup="DayOfWeeek">
                    <cellContents/>
                </crosstabCell>
                <crosstabCell width="60" height="20" rowTotalGroup="empNumber" columnTotalGroup="DayOfWeeek">
                    <cellContents/>
                </crosstabCell>
            </crosstab>
        </band>
    </summary>
</jasperReport>

Following is the output https://ibb.co/ZS19TST

I have 2 requirements:

  1. I would like to show the sum for two rows – Total and Extra.
  2. For the Sunday columns cells, I would like to have gray color as the background.

For the second item, I know that we can use conditional style. I have tried using it but I could not get it to work. I would appriciate any help.

Leave a Comment