How to fill the background color of the cells in the pivot chart based on condition on group totals

[trdandamudi]

Hello,

I need help regarding background color of the cells in the pivot chart based on a condition on sub totals . Attached is the qvw file (version 12). Below is my required output.

Thanks

[Zhandos_Shotan · Accepted solution]

Hi!

BackgroundColor expression option: if(sum(total<Region, Country>Amount)<520, Yellow(), Black(100))

Check attach

Regards

[trdandamudi]

Thank  you for your time and it helped.