Conditional formatting in Pivot Table for values (taken in aggregate) that are higher than a threshold.

[Excel addicted]

Dear Excel Community !
I hope you are all doing well
I come with a question that it seems not raised before as far as I know. I would like to get certain values within a pivot table getting highlighted dynamically provided that the total of theses values are higher than a threshold ( 80 % of the grand total in this case). The values to be highlighted need to be in logical order, from the Largest valued to the lowest value whose sum will be above the threshold (see screenshot below).
If possible the formatting can be kept the same even if the values are not sorted (from Largest to Smallest).
Any idea how to tackle this issue ?

Thanks in advance for your help !

 

[James006]

Hi,

Debra Dalgleish has designed many examples for Pivot Table Conditional Formatting :

Add Pivot Table Conditional Formatting and Fix Problems

Avoid pivot table conditional formatting problems! Short video shows easy setup steps. Follow along with free workbook. How to fix problems on pivot refresh

www.contextures.com

 

[Excel addicted]

Hi,

Debra Dalgleish has designed many examples for Pivot Table Conditional Formatting :

Add Pivot Table Conditional Formatting and Fix Problems

Avoid pivot table conditional formatting problems! Short video shows easy setup steps. Follow along with free workbook. How to fix problems on pivot refresh

www.contextures.com

Hello,
Thanks for the reference. The issue presented in my post doesn't fall within any of the examples presented by Debra Dalgleish.
In my case the highlight will be if the Sum of multiple values are above a set amount. I hope it was clear

 

[James006]

It seems to me the main point is how have you designed your Formula for your conditional formatting ...

Would you mind sharing it ?

 

[Excel addicted]

It seems to me the main point is how have you designed your Formula for your conditional formatting ...

Would you mind sharing it ?

I would have gladly shared the formula if I have designed it because I'm looking for a formula actually which will resolve the situation described previously. I'm thinking that the formula may contain the following: SUM() ; LARGE(); IF(). I will try to come up with a combination and share it with you if it works.
Sorry for creating such confusion

 

[James006]

May be to simplify your life you could have a Running Total by customer ... should be worth testing ...

 

[James006]

Just out of curiosity, have you fixed your problem ...

 

[Excel addicted]

Just out of curiosity, have you fixed your problem ...

Thanks for the follow-up! Actually, I put it on hold for the time being as I have to deal with other urgent issues. My brain needs to be on a rest mode to focus on Excel issues. I will let you know once solved