How to show Actual Grand Total rather than "Grand Total"

Mickey
Mickey Member
in Cards, Dashboards, Stories

Hello,

I have a card built that only has two columns, and both columns have numerical values that I need to see a total of. However, when I activate the Grand Total option for the card, instead of showing an actual total it has the "Grand Total" text since it is the first column on the card, and I cannot add any other columns for this project. Is there any way to show only the totals instead of having the text "Grand Total?"

Screen Shot 2023-06-22 at 4.24.25 PM.png
Tagged:

Answers

  • Jones01
    Jones01 Contributor

    @Mickey This can be achieved by using the HTML Table chart type.

  • MichelleH
    MichelleH Coach

    @Mickey You can hide the "Grand Total" label by adding "<br>" in the Label under "Total Row"

    image.png
  • GrantSmith
    GrantSmith Coach

    Due to how Domo processes grand totals it puts the GRAND TOTAL in the first column that's available even though you're wanting to display the total amounts. To get around the issue you'd need to have another column at the far left to hold the GRAND TOTAL text and allow your LY Retail Sales column to display it's actual total.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories