Top 6 By Month in Chart

[brcovenantpp]

I have a bar chart with 1 dimension and 1 measure, by month. I want to show the top 6 dimensions(Total sales) for each month. I know you can use the top/bottom buttons with an expression defining the amount you want. Want I want to try to do is conditionally format dimensions that weren't in the previous month's top 6. So if a new dimension enters the top 6 in June, and wasn't in the top 6 in May, it's bar is colored red. Not sure if this can be done, but any help would be greatly appreciated. Thank you. 

[sidhiq91]

@brcovenantpp  Could you please provide some data and also the expected output that you are looking for.

[brcovenantpp]

This is one of my charts. What I'd like to do is, if one of the columns isn't present in the previous quarter's top 6, add a conditional format that would color the bar red to indicate it's new to the top 6.