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

Options
Barb
Barb Member
in Cards, Dashboards, Stories

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 ✓
    Options

    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 ✓
    Options

    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
    Options

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

Categories