Cognos Crosstab Row Label Problem

<report xmlns="http://developer.cognos.com/schemas/report/15.5/" expressionLocale="en-us" useStyleVersion="11.6">
    <!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/13.1/" to "http://developer.cognos.com/schemas/report/15.5/" at 2021-3-25. 18:21:59-->
    <drillBehavior/>
    <layouts>
        <layout>
            <reportPages>
                <page name="Page1">
                    <style>
                        <defaultStyles>
                            <defaultStyle refStyle="pg"/>
                        </defaultStyles>
                    </style>
                    <pageBody>
                        <style>
                            <defaultStyles>
                                <defaultStyle refStyle="pb"/>
                            </defaultStyles>
                        </style>
                        <contents>
                            <crosstab horizontalPagination="true" name="Crosstab1" refQuery="Query2">
                                <crosstabCorner>
                                    <contents/>
                                    <style>
                                        <defaultStyles>
                                            <defaultStyle refStyle="xm"/>
                                        </defaultStyles>
                                    </style>
                                </crosstabCorner>
                                <noDataHandler>
                                    <contents>
                                        <block>
                                            <contents>
                                                <textItem>
                                                    <dataSource>
                                                        <staticValue>No Data Available</staticValue>
                                                    </dataSource>
                                                </textItem>
                                            </contents>
                                            <style>
                                                <CSS value="padding:16px;"/>
                                            </style>
                                        </block>
                                    </contents>
                                </noDataHandler>
                                <style>
                                    <CSS value="border-collapse:collapse"/>
                                    <defaultStyles>
                                        <defaultStyle refStyle="xt"/>
                                    </defaultStyles>
                                </style>
                                <crosstabColumns>
                                    <crosstabNode>
                                        <crosstabNodeMembers>
                                            <crosstabNodeMember refDataItem="Year" edgeLocation="e1">
                                                <style>
                                                    <defaultStyles>
                                                        <defaultStyle refStyle="ml"/>
                                                    </defaultStyles>
                                                </style>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <memberCaption/>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                                <sortList>
                                                    <sortItem refDataItem="Year"/>
                                                </sortList>
                                            </crosstabNodeMember>
                                        </crosstabNodeMembers>
                                    </crosstabNode>
                                </crosstabColumns>
                                <crosstabFactCell>
                                    <contents>
                                        <textItem>
                                            <dataSource>
                                                <cellValue/>
                                            </dataSource>
                                        </textItem>
                                    </contents>
                                    <style>
                                        <defaultStyles>
                                            <defaultStyle refStyle="mv"/>
                                        </defaultStyles>
                                    </style>
                                </crosstabFactCell>
                                <crosstabRows>
                                    <crosstabNode>
                                        <crosstabNodeMembers>
                                            <crosstabNodeMember refDataItem="This Country Value" edgeLocation="e2">
                                                <style>
                                                    <defaultStyles>
                                                        <defaultStyle refStyle="ml"/>
                                                    </defaultStyles>
                                                </style>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <reportExpression>ParamDisplayValue(&apos;country&apos;)</reportExpression>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                            </crosstabNodeMember>
                                        </crosstabNodeMembers>
                                    </crosstabNode>
                                    <crosstabNode>
                                        <crosstabNodeMembers>
                                            <crosstabNodeMember refDataItem="Region Value" edgeLocation="e3">
                                                <style>
                                                    <defaultStyles>
                                                        <defaultStyle refStyle="ml"/>
                                                    </defaultStyles>
                                                </style>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <dataItemValue refDataItem="This Region"/>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                            </crosstabNodeMember>
                                        </crosstabNodeMembers>
                                    </crosstabNode>
                                    <crosstabNode>
                                        <crosstabNodeMembers>
                                            <crosstabNodeMember refDataItem="All Americas Value" edgeLocation="e4">
                                                <style>
                                                    <defaultStyles>
                                                        <defaultStyle refStyle="ml"/>
                                                    </defaultStyles>
                                                </style>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <dataItemLabel refDataItem="All Americas Value"/>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                            </crosstabNodeMember>
                                        </crosstabNodeMembers>
                                    </crosstabNode>
                                    <crosstabNode>
                                        <crosstabNodeMembers>
                                            <crosstabNodeMember refDataItem="Global Value" edgeLocation="e5">
                                                <style>
                                                    <defaultStyles>
                                                        <defaultStyle refStyle="ml"/>
                                                    </defaultStyles>
                                                </style>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <dataItemLabel refDataItem="Global Value"/>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                            </crosstabNodeMember>
                                        </crosstabNodeMembers>
                                    </crosstabNode>
                                </crosstabRows>
                            </crosstab>
                        </contents>
                    </pageBody>
                </page>
            </reportPages>
            <promptPages>
                <page name="Prompt page1">
                    <pageHeader>
                        <contents>
                            <block>
                                <contents>
                                    <textItem>
                                        <dataSource>
                                            <staticValue/>
                                        </dataSource>
                                        <style>
                                            <defaultStyles>
                                                <defaultStyle refStyle="tt"/>
                                            </defaultStyles>
                                        </style>
                                    </textItem>
                                </contents>
                                <style>
                                    <defaultStyles>
                                        <defaultStyle refStyle="ta"/>
                                    </defaultStyles>
                                </style>
                            </block>
                        </contents>
                        <style>
                            <defaultStyles>
                                <defaultStyle refStyle="hp"/>
                            </defaultStyles>
                        </style>
                    </pageHeader>
                    <pageBody>
                        <contents>
                            <table>
                                <style>
                                    <defaultStyles>
                                        <defaultStyle refStyle="tb"/>
                                    </defaultStyles>
                                    <CSS value="border-collapse:collapse"/>
                                </style>
                                <tableRows>
                                    <tableRow>
                                        <tableCells>
                                            <tableCell>
                                                <contents>
                                                    <textItem>
                                                        <dataSource>
                                                            <staticValue>Country:</staticValue>
                                                        </dataSource>
                                                    </textItem>
                                                </contents>
                                                <style>
                                                    <CSS value="text-align:left;vertical-align:top"/>
                                                </style>
                                            </tableCell>
                                            <tableCell>
                                                <contents>
                                                    <selectValue parameter="country" refQuery="country">
                                                        <useItem refDataItem="Country">
                                                            <displayItem refDataItem="Country"/>
                                                        </useItem>
                                                        <sortList>
                                                            <sortItem refDataItem="Country"/>
                                                        </sortList>
                                                    </selectValue>
                                                </contents>
                                                <style>
                                                    <CSS value="text-align:left;vertical-align:top"/>
                                                </style>
                                            </tableCell>
                                        </tableCells>
                                    </tableRow>
                                    <tableRow>
                                        <tableCells>
                                            <tableCell colSpan="2">
                                                <contents>
                                                    <promptButton type="cancel">
                                                        <contents/>
                                                        <style>
                                                            <defaultStyles>
                                                                <defaultStyle refStyle="bp"/>
                                                            </defaultStyles>
                                                        </style>
                                                    </promptButton>
                                                    <promptButton type="finish">
                                                        <contents/>
                                                        <style>
                                                            <defaultStyles>
                                                                <defaultStyle refStyle="bp"/>
                                                            </defaultStyles>
                                                        </style>
                                                    </promptButton>
                                                </contents>
                                                <style>
                                                    <CSS value="text-align:left;vertical-align:top"/>
                                                </style>
                                            </tableCell>
                                        </tableCells>
                                    </tableRow>
                                </tableRows>
                            </table>
                        </contents>
                        <style>
                            <defaultStyles>
                                <defaultStyle refStyle="py"/>
                            </defaultStyles>
                        </style>
                    </pageBody>
                    <style>
                        <defaultStyles>
                            <defaultStyle refStyle="pp"/>
                        </defaultStyles>
                    </style>
                </page>
            </promptPages>
        </layout>
    </layouts>
    <XMLAttributes>
        <XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/>
        <XMLAttribute name="RS_modelModificationTime" output="no" value=""/>
        <XMLAttribute name="listSeparator" output="no" value=","/>
        <XMLAttribute output="no" name="decimalSeparator" value="."/>
    </XMLAttributes>
    <queries>
        <query name="Query1">
            <source>
                <model/>
            </source>
            <selection>
                <dataItem aggregate="none" rollupAggregate="none" name="Year">
                    <expression>[Sales (query)].[Time].[Year]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="1"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
                    </XMLAttributes>
                </dataItem>
                <dataItem aggregate="none" rollupAggregate="none" name="Country">
                    <expression>[Sales (query)].[Branch].[Country]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="3"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
                    </XMLAttributes>
                </dataItem>
                <dataItem name="Region" aggregate="none" rollupAggregate="none">
                    <expression>case when [Sales (query)].[Branch].[Country] in (&apos;Canada&apos;, &apos;Mexico&apos;, &apos;United States&apos;) then &apos;North America&apos; when [Sales (query)].[Branch].[Country] in (&apos;Brazil&apos;) then &apos;South America&apos; else &apos;Other&apos; end</expression>
                </dataItem>
                <dataItem name="This Region" aggregate="none" rollupAggregate="none">
                    <expression>case when ?country? in (&apos;Canada&apos;, &apos;Mexico&apos;, &apos;United States&apos;) then &apos;North America&apos; when ?country? in (&apos;Brazil&apos;) then &apos;South America&apos; end</expression>
                </dataItem>
                <dataItem aggregate="total" name="Revenue">
                    <expression>[Sales (query)].[Sales].[Revenue]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="2"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
                    </XMLAttributes>
                </dataItem>
            </selection>
        </query>
        <query name="Query2">
            <source>
                <queryRef refQuery="Query1"/>
            </source>
            <selection>
                <dataItem aggregate="none" rollupAggregate="none" name="Year">
                    <expression>[Query1].[Year]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="1"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
                    </XMLAttributes>
                </dataItem>
                <dataItem name="This Country Value" aggregate="total" rollupAggregate="total">
                    <expression>case when [Query1].[Country] = ?country? then [Query1].[Revenue] else 0 end</expression>
                </dataItem>
                <dataItem aggregate="none" rollupAggregate="none" name="This Region">
                    <expression>[Query1].[This Region]</expression>
                </dataItem>
                <dataItem name="Region Value" aggregate="total" rollupAggregate="total">
                    <expression>case when [Query1].[Region] = [Query1].[This Region] then [Query1].[Revenue] else 0 end</expression>
                </dataItem>
                <dataItem aggregate="total" name="All Americas Value">
                    <expression>case when [Query1].[Region] &lt;&gt; &apos;Other&apos; then [Query1].[Revenue] else 0 end</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="2"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
                    </XMLAttributes>
                </dataItem>
                <dataItem aggregate="total" name="Global Value">
                    <expression>[Query1].[Revenue]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="2"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value="2"/>
                    </XMLAttributes>
                </dataItem>
            </selection>
        </query>
        <query name="country">
            <source>
                <model/>
            </source>
            <selection>
                <dataItem aggregate="none" rollupAggregate="none" name="Country">
                    <expression>[Sales (query)].[Branch].[Country]</expression>
                    <XMLAttributes>
                        <XMLAttribute output="no" name="RS_dataType" value="3"/>
                        <XMLAttribute output="no" name="RS_dataUsage" value="0"/>
                    </XMLAttributes>
                </dataItem>
            </selection>
            <detailFilters>
                <detailFilter>
                    <filterExpression>[Country] in (&apos;Brazil&apos;, &apos;Canada&apos;, &apos;Mexico&apos;, &apos;United States&apos;)</filterExpression>
                </detailFilter>
            </detailFilters>
        </query>
    </queries>
    <modelPath>/content/folder[@name=&apos;Samples&apos;]/folder[@name=&apos;Models&apos;]/package[@name=&apos;GO sales (query)&apos;]/model[@name=&apos;model&apos;]</modelPath>
</report>