How to check two dates and the [total] value on each date to set a color rule

[Tiger1]

I want to check my date column.  In the [date] column I want to check between - today's date and yesterdays date.  I want to check if the [total] from yesterday is smaller or bigger than todays.  Also, this needs to be PER [location] column and per [ category] column:

[Joseph_Seddik]

1. Create a slice for today's records.
2. Create a slice for yesterday's records.
3. Then:  Re: FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), R... - Google Cloud Community  

[Tiger1]

How do I combine the two slices to create the color rule I need?  I need color "red" if yesterdays total was less than todays.  I need "green" if yesterdays totals were more than todays.

[Joseph_Seddik · Accepted solution]

I guess you'd need to compare the two totals rather than "combine" them. So you'd use < and > to compare the calculated totals. 

[Tiger1]

How do I compare slices?  Would these need to be virtual columns?