How do I get color rules to apply to all pivot table levels?

Options
Barb
Barb Member
in Dashboards

I want to apply color rules to a pivot table that shows weekly, monthly and quarterly results. I can set the rules to the weekly level, but they are not applying to the monthly or quarterly roll-ups:

image.png

You can see above that the %Diff Column is showing the colors, but the '1 Total' columns on the far right do not.

Any suggestions on how to have these rules apply at all levels of the pivot?

Best Answer

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    Make sure you check this box in the "general" properties.

    image.png

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

    Please accept the answer if it solved your problem.

Answers

  • DavidChurchman
    DavidChurchman Coach
    Answer ✓

    Make sure you check this box in the "general" properties.

    image.png

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

    Please accept the answer if it solved your problem.

  • Barb
    Barb Member

    And just like that you solved three issues for me - Thank you!! 💖

Categories