Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In that pivot table i would like to be able to compare May and April to define if May ir greater/equal/less than Apr and be able to give it a specifir color, but I'd like to be able to change the months and keep it working
Hi
here below an example
add this mesure in the color expression panel of your mesure :
if(before(column(1))>column(1),green(),LightRed())
so no matter how much Months is displayed (2 , 3 or more ) it will compare month column value with previous month column value and give it specified color depending of the result.
adapt this mesure if you want an equal comparison by adding an if statement
regards