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

Options
Jay.p
Jay.p Member
edited May 16 in Charting & Analyzer

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