Changing color of pivot table cells based on previous cell comparison
I am new to Qlik and working on my first project as a "learning" experience. I am using Qlik Sense 3.1.
I attached a pivot table I am working on. I need to change the cell colors based on a comparison between the current cell value and the
previous cell value. For example: In the monthly revenue pivot table I attached, I need for October amounts to be black text. For November, each year's total is < those in October, so all those should be red. For December, 2013/2014 amount should be red because it is < Novembers total. December's 2014/2015 and 2015/2016 should be green because they are > the amounts for November same year. Dec 2016/2017 should be red because it is < November 2016/2017 amount...and on throughout the table. I don't know where to begin to write this expression. Any help would be greatly appreciated!