Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi!
BackgroundColor expression option: if(sum(total<Region, Country>Amount)<520, Yellow(), Black(100))
Check attach
Regards
Hi!
BackgroundColor expression option: if(sum(total<Region, Country>Amount)<520, Yellow(), Black(100))
Check attach
Regards
Thank you for your time and it helped.