Color rules in Pivot table for "Total" and "Subtotal" value

Jay.p
Jay.p Member
edited May 16 in Charting

Can you please help me to know "How to apply Color rules in Pivot table for "Total" and "Subtotal" value?"

When I applied color rules, it only highlights the value of each part instead of including "subtotal" and "Total" in Pivot table.

Thankyou!

Screenshot 2025-05-16 091257.png

Color rule

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    There's a checkbox to apply the color rules to totals and subtotals in the "general" section of chart properties:

    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

Answers

  • ArborRose
    ArborRose Coach

    I don't think you can apply a color rule to the default totals provided by the chart. Domo's color rules do not distinguish between details and totals. They color based on a condition or value. I think you have to create your own totals using beast mode, if you want to color them.

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

  • Jay.p
    Jay.p Member

    Thanks for sharing!

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    There's a checkbox to apply the color rules to totals and subtotals in the "general" section of chart properties:

    image.png

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • Jay.p
    Jay.p Member

    @DavidChurchman Yes, that works. Thanks a lot for detailed answer!

Categories