Used the following script to create a flag:
LOAD Month(Date#(Month, 'MMMM')) as Month,
LOAD * INLINE [
Month, Country, Status
May, India, High
June, India, Low
July, India, Low
May, Japan, Low
June, Japan, Low
July, Japan, Low
If(Country = Previous(Country) and Status <> Previous(Status), 1, 0) as Flag
Order By Country, Month;
DROP Table Table;
and then used the following background expression:
=If(Flag = 1, LightRed())
Community_219780.qvw 152.5 K
As long as you have data for all Months you don't really need to check for Month because I would hope them to be incremental. But if there is a case that the data might be missing for some months and you want a different flag when that is the case, you might have to use Month in the condition as well. It all depends on your what you need.
How is the Pivot Table structured? May be this?
I see that different positioning of dimensions lead to different results, so it would be best if you can open the file and adjust the pivot table to your need and reattach it.
Community_219780_v1.qvw 155.0 K