Color background color based on column partial sum
Thank you. That works!
I can start another post but I just tried making the pivot table a little more multi-dimensional by adding Sale Year to it, so now it looks like this:
Using the formula above worked when it wasn't by year but now it appear the TOTAL portion of that expression totals all columns up? So, since the overall percentage is 53% (131+61/260+100), Dog collar in 2011 is showing up RED since it's below 53% but really it should be blue because it's above 50% for that specific year. Does that make sense?
Is there a way to get the partial sum for the column instead of the total sum for all the columns?