Crosstab row total using relation query

[patrickthatcher]

Howdy. I have a multi-fact crosstab report using a relational query.  I have the column totals, but the users would now like a row total based off the GROUP_FIELD.  How would I go about doing this?

                                                         |      GROUP_FIELD              |
                                                         |    <Date_Range>               |
                                                         |  <Sls $>       | <Sls U>      |
~~~~~~~~~~                                |
<#Field_1#>   |<#Field_1#>          | <#1234#>   |<#1234#>  |   Total $   |  Total U|   

Thank you

[patrickthatcher]

If it wasn't readily apparent, the issue I'm facing is that my crosstab contains multiple facts

[patrickthatcher]

Got help from a different source.  Here's how to setup in case you need to do this:

• Add the top column - GROUP_FIELD
• Add Metrics fields needed
• Add the next column TO THE LEFT OF the metrics just added- Date_Range
• from the available fields add the same metrics underneath the Date_Range column

                                                         |      GROUP_FIELD                                                            |
                                                         |    <Date_Range>               |  <Sls $>       |  <Sls U>      |
                                                         |  <Sls $>       | <Sls U>      |
~~~~~~~~~~~~~~~~~~~~~~  |
<#Field_1#>   |<#Field_1#>          | <#1234#>   |<#1234#>  |   <#1234#>  | <#1234#> |