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
If it wasn't readily apparent, the issue I'm facing is that my crosstab contains multiple facts
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#> |