Compare columns in a pivote table

Luis_Gueerero13 — Thu, 27 May 2021 19:05:45 GMT

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

Re: Compare columns in a pivote table

brunobertels — Fri, 28 May 2021 06:34:30 GMT

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

topic Compare columns in a pivote table in App Development

Compare columns in a pivote table

Re: Compare columns in a pivote table